if uppercase(left({table.customername},1)) in ["A","R","S","T","U","V","W","X","Y","Z"]
then "Dagmar"
else "Inge"
That will work provided the first letter in the customername string is the letter you want to take into consideration, ie if you want the first letter of the surname the above formula will only work if your string is as follows;
Surname, Firstname
it won't work if the string is;
Firstname Surname
Regards,
Ryan.
IP Logged
