What's wrong this T-SQL statement?

Question

Why is this throwing an error on the equal sign?

select IIF((SUBSTRING('A1234', 1, 1) = 'A'), TRUE, FALSE) as IsAustraliaUser

Error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '='.

Answer 1

IIF is a SQL Server 2012 feature, you'll need to use CASE

SELECT CASE SUBSTRING('A1234', 1, 1)
       WHEN 'A' THEN 'TRUE'
       ELSE 'FALSE'
       END

Answer 2

You should replace IIF with CASE, also TRUE and FALSE don't exists in SQL Server, you can use VARCHAR or BIT

select CASE WHEN SUBSTRING('A1234', 1, 1) = 'A' THEN 'TRUE' ELSE 'FALSE' END as IsAustraliaUser