>>>I am trying to use IF logic in SELECT statement. any ideas?
>>
>>Try formating it like this:
>>
>>SELECT IIF(alias.gender = "M", "Male", "Female") AS GenderText FROM Customers
>>
>>M.
>
>You need to make sure you pad out the field to the proper number of characters. Otherwise if the first record selected is "Male" the others will get truncated to "Fema"
>
>use PADR()
>
>or simply
>
>IIF(alias.gender = "M", "Male ", "Female")
---------
Hi Dan and thanks for reminding me...:)