sql server data mining: I have 5 fields:

Name SpendAmount RecommendedAmount AmountOver Compliant
Jo 5000 3000 2000 Yes
Donna 2000 4000 0 No


I want to be able to generate the output in [Compliant] with an iif or CASE statements but either way I keep getting this error: Incorrect syntax near '>' in this part of my SELECT Statement.

iif(SpendAmount > RecommendedAmount, 'Yes', 'No') as Compliant

What am doing it wrong?

Thank you for your input and help.

Diana,

SQL has no IIF syntax; try the following CASE statement:

CASE
WHEN SpendAmount > RecommendedAmount THEN 'Yes'
ELSE 'No'
END as Compliant



[quoted text, click to view]
CASE statements but either way I keep getting this error: Incorrect
syntax near '>' in this part of my SELECT Statement.
[quoted text, click to view]

There is no iff statement in T-SQL. You need to use the CASE statement

[quoted text, click to view]
CASE statements but either way I keep getting this error: Incorrect
syntax near '>' in this part of my SELECT Statement.
[quoted text, click to view]