>SELECT icase(intSaletype = 1, 'Sale', intSaletype = 2, 'Return', 'Something else') as SaleType from table >>
>>"Can either of you tell me what the syntax is to do a CASE statement in a db lookup, for a fox pro db. >> >>This is what it would look like for sql server: >> >>SELECT ‘Sale Type’ = CASE intSaletype WHEN 1 THEN ‘Sale’ WHEN 2 THEN ‘Return’ ELSE ‘Something else’ END >>FROM <table> >>" >>>>Any idea? I am not skilled mssql, so that's why I'm asking you gurus....