CASE Statement in SQL Query
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'
END as 'Result'
Is this not possible with FileMaker via ODBC?