[thelist] MS SS7 - SELECT [computed field] syntax question

r937 rudy at r937.com
Fri Jan 25 11:20:49 CST 2008

i think your problem might have been the doublequotes

"XX" is a column

'XX' is a string

(too much ms access in your background, perhaps)

also, stay away from IF, use CASE whenever possible

   SELECT Field_1
        , Field_2
        , Field_3
        , CASE WHEN Field_1 = 'XX'
                AND Field_2 = 'YY'
               THEN 'New Value'
               ELSE Field_3 END     AS New_Field_3
     FROM daTable


More information about the thelist mailing list