I have the following requirement for a computed column, based on the contents of another column in the same table. If the amount is less than 0, the value should be C otherwise it's value should be D.
I have used the following notation in the computed column specification;
CASE [monAmount] WHEN < 0 THEN 'C' ELSE 'D'
It will not validate. Why?