SQL IF ELSE Calculated Column

Question

I'm trying to set a column value to "Vacant" or "Full" based on another column value. So an example would be: If Column X = 0 Then Column Y Value = "Full" Else Column Y Value = "Vacant".

Thanks!

You need to use CASE statement in SQL,[this](http://stackoverflow.com/questions/5487892/sql-server-case-when-or-then-else-end-the-or-is-not-supported) so answer has an example. — Darshan Mehta, Nov 18 '15 at 09:39
Sounds like a bad idea. Why store same value twice, once as 0 and once as FULL... May end up with data inconsistency. Create a view instead! (If you really need to do this, handle it with triggers, or as a "computed column".) — jarlh, Nov 18 '15 at 09:48

score 4 · Accepted Answer · answered Nov 18 '15 at 09:39

4

Use CASE

UPDATE t SET ColumnY = (CASE WHEN ColumnX = 0 THEN 'Full' ELSE 'Vacant' END)

answered Nov 18 '15 at 09:39

Tim Schmelter

450,073
74
686
939

Thanks! I will try this. – Erik Lydecker Nov 18 '15 at 16:35

SQL IF ELSE Calculated Column

1 Answers1