1 2 Previous Next 16 Replies Latest reply on Aug 4, 2009 10:41 AM by TSGal

    CASE Statement in SQL Query

    nateborland

      Title

      CASE Statement in SQL Query

      Your post

      I'm trying to use a basic CASE statement in a query against FileMaker Sever Advanced v10 via ODBC (SequeLink) and I keep getting a "parse error in SQL" error. The syntax is as follows:

       

      SELECT CASE A1

      WHEN 'Yes' THEN '1'

      ELSE '0'
      END as 'Result'
      FROM Audits

       

      Is this not possible with FileMaker via ODBC?

        1 2 Previous Next