SELECT CASE Syntax Error

Question

I have the following @temp table :

------------------------------------
|Condition_ID   Operator   Order    |
|     1            ==        1      |
|     2            <>        3      |
|     3            ==        2      |
------------------------------------

I want to implement a SELECT CASE that will output a certain message depending on the Operator

However this throws me an Incorrect syntax near the keyword 'PRINT'. error.

SELECT CASE
    WHEN Operator LIKE '=='
        THEN PRINT 'EQUALS'
    WHEN Operator LIKE '<>'
        THEN PRINT 'NOT EQUALS'
END AS Operator
FROM @temp

What am I doing wrong?

score 1 · Answer 1 · answered Nov 27 '12 at 10:56

1

You cannot mix PRINT and SELECT

SELECT CASE WHEN Operator LIKE '=='
            THEN 'EQUALS'
            WHEN Operator LIKE '<>'
            THEN 'NOT EQUALS'
       END AS Operator
FROM @temp

answered Nov 27 '12 at 10:56

juergen d

201,996
37
293
362

Does that mean I cannot use `PRINT`? – hermann Nov 27 '12 at 10:57
Do you explicitly need PRINT? – juergen d Nov 27 '12 at 11:00
No, but I would like to know if it possible to use it. – hermann Nov 27 '12 at 11:01
You can't use select and print at the same time. – juergen d Nov 27 '12 at 11:08

Kirk Broadhurst · Accepted Answer · 2012-11-27T11:10:58.950

1

You just need to remove the PRINT

SELECT CASE
    WHEN Operator LIKE '=='
        THEN 'EQUALS'
    WHEN Operator LIKE '<>'
        THEN 'NOT EQUALS'
END AS Operator
FROM @temp

You can't use a PRINT inside a SELECT, and you don't need to - the SELECT will retrieve the appropriate value for you.

edited Nov 27 '12 at 11:10

answered Nov 27 '12 at 11:00

Kirk Broadhurst

27,836
16
104
169

1

you need to add an 'END' before the 'AS'. good answer, thank you. – hermann Nov 27 '12 at 11:09

score 0 · Answer 3 · answered Nov 27 '12 at 11:05

0

this works ::

   SELECT CASE
    WHEN opr LIKE '=='
        THEN 'EQUALS'
    WHEN opr LIKE '<>'
        then 'NOT EQUALS'
    else
        'wrong i/p'
    end
as operator
FROM tbl1;

answered Nov 27 '12 at 11:05

Ajith Sasidharan

1,155
7
7

score 0 · Answer 4 · answered Nov 27 '12 at 11:07

0

Try this ,there is no print option

SELECT CASE 
        WHEN Operator LIKE '=='
        THEN 'EQUALS'
        WHEN Operator LIKE '<>'
        THEN 'NOT EQUALS'
   END AS Operator
   FROM @temp

answered Nov 27 '12 at 11:07

Viru

525
2
7
15

SELECT CASE Syntax Error

4 Answers4