T-SQL doesn't have IIF() function. Use CASE
SELECT (CASE WHEN @price < 0 THEN 'red' ELSE 'black' END) As Color
>
>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 '<'.
--sb--