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

Note the subtle insertion of LEFT before the join, so you may get a few people with NULL gender... besides, they should be entitled to delaying the decision until they grow up :)