>CREATE TABLE Test (Test c(10)) >INSERT INTO test VALUES ("1") >INSERT INTO test VALUES ("2") >SELECT ICase(Test="1","1","22") FROM Test >>
>SELECT cast(icase(test="1","1","22") as character(10)) FROM test >>
>>"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....