CREATE TABLE Test (Test c(10)) INSERT INTO test VALUES ("1") INSERT INTO test VALUES ("2") SELECT ICase(Test="1","1","22") FROM Testso better would be in my opinion:
SELECT cast(icase(test="1","1","22") as character(10)) FROM test>Hey Guys.....
>"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....