>>>SELECT IIF(alias.gender = "M", "Male", "Female") AS GenderText FROM Customers
>>that works...thanks...:)
>
>IIF won't work in SQL Server though, if that applies. Your best bet, to make it scaleable or simpler in VFP would be to have a table like this:
>

gender.dbf
>code	gender
>--------------
>m	Male
>f	Female

>and then build your SQL like this:
>
>SELECT gender.gender FROM alias LEFT JOIN gender ON alias.gender = gender.code
------------
ok Mike - thanks for the reply...:)