If else Statement by MSSQL Statement

Question

0.00/5 (No votes)

See more:

how should I write for select statement including if else condititon

I write as below statement and give error, so how should I write for that

SQL

ORDER.Order_Id as 'id',
ORDER.Released
IF(ORDER.Released = 1) PRINT 'Released'
ELSE PRINT 'Not Released'
from ORDER

thanks,
ttds

Posted 17-Jan-13 15:54pm

ttds

Updated 17-Jan-13 17:14pm

v2

Comments

PIEBALDconsult 17-Jan-13 22:12pm

I can't tell what you want, but maybe you want CASE ORDER.Released THEN 'Released' ELSE 'Not Released' END

PIEBALDconsult 17-Jan-13 22:12pm

Are you looking for

CASE ORDER.Released WHEN 1 THEN 'Released' ELSE 'Not Released' END?

Oh, sure, now the earlier post shows up. :rolleyes:

1 solution

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David_Wimbley · Accepted Answer · 2013-01-17T16:20:00

This should do it

SQL

SELECT
    O.Order_ID AS 'id',
    O.Released,
    CASE WHEN O.Released = 1 THEN 'Released' ELSE 'Not Released' END AS ReleaseStatus
FROM Order AS O

Posted 17-Jan-13 16:20pm

Updated 17-Jan-13 17:04pm

v2