AnsweredAssumed Answered

CASE Statement in SQL Query

Question asked by nateborland on Jul 7, 2009
Latest reply on Aug 4, 2009 by TSGal

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?

Outcomes