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

Ooh, nice save, Mike. Something to think about next time....