>>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. ---------- Hi Marty, that works...thanks...:)
Robert Keith Independent Developer San Antonio, Texas E-mail address: rebelrob1@yahoo.com