Skip to Content
0
Aug 19, 2016 at 01:48 PM

Problem with case statement

39 Views

Hi,

I don't know why it doesn't work, by I can't make any sql with "case".

Example:

SELECT CASE T0.[NextNumber] WHEN 6 THEN 'AAA' ELSE 'A' FROM NNM1 T0

And the syntax error near 'FROM' appears.

I tried use another apostrophes and more, but nothing works..