Hi all,

Can somebody explain why I got error in here,

declare @price as int
set @price = 5
SELECT iif( @price < 0 , 'red', 'black' )


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