Select value if condition in SQL Server

Question

In a query selection I would like to display the result whether a field satisfies a condition.

Imagine that I have a table called stock. This table has a column that tells me the number of each item in the stock.

What I would like to do is something like this:

SELECT 
    stock.name, IF (stock.quantity <20, "Buy urgent", "There is enough")
FROM stock

Is there any function in SQL Server to do that?

score 65 · Accepted Answer · answered Jul 11 '13 at 16:14

65

SELECT   stock.name,
      CASE 
         WHEN stock.quantity <20 THEN 'Buy urgent'
         ELSE 'There is enough'
      END
FROM stock

answered Jul 11 '13 at 16:14

Ram

I'll use this but seems such a shame to have to do this when all I want is a boolean value. can't see why mssql can't let me do "select (stock.quantity <20) As booleanValue" – Joshua Duxbury Oct 05 '16 at 11:07
1

@JoshuaDuxbury If you want a boolean value you can try something like http://stackoverflow.com/a/7778500/2246380 – Ram Oct 05 '16 at 15:30

score 6 · Answer 2 · answered Jul 11 '13 at 16:11

6

answered Jul 11 '13 at 16:11

Daniel Hollinrake

2 Answers2