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