CODEWITHSUNDEEP
sql
Erik Lydecker
Erik Lydecker

Reputation: 717

SQL IF ELSE Calculated Column

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!

Upvotes: 0

Views: 54

Answers (1)

Tim Schmelter
Tim Schmelter

Reputation: 460158

Use CASE

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

Upvotes: 4

Related Questions