>>>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...:)