SQL Query with CASE WHEN

[sqltimmy]

I'm getting syntax errors about missing operators when I use a query that is similar to:

SELECT CASE
WHEN (column1 > 0) THEN '1'
WHEN (column1 = 0) THEN '0'
WHEN (column1 < 0) THEN '-1'
END AS field1
FROM table1

It works fine in MS SQL Server, where I first wrote the query, but apparently copying and pasting it into an Access query doesn't work. Does anyone know the syntax for a CASE WHEN statement, or an alternative? Thanks!

 

[mikevh]

SELECT IIF(column1 > 0,'1',IIF(column1=0,'0','-1')) AS field1
FROM table1;