>>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
