Incorrect syntax near '='.

Question

Trying to write a case condition query, but fail to this error: Incorrect syntax near '='.

Here is my query:

select case field1         
       when field1 = '1' then 'true'         
       when field1 = '0' then 'false' end 
FROM temptable

Tried removing single quotes of 1, but not worked.

Answer 1

Hi @Lylyy

It is a syntax error, see this doc: CASE (Transact-SQL)

Try this:

select case 
       when field1 = '1' then 'true'              
       when field1 = '0' then 'false' end 
FROM temptable  

--or  

select case field1        
       when '1' then 'true'         
       when '0' then 'false' end 
FROM temptable

Best regards,

Cosmog Hong