|
help
Login
|
Register
vmonpara
's code bookmark
Tag:
syntax
→ view
all
Tags
ASP .Net
SQL Server
General
InfoPath
javascript
Tag: syntax
« previous | next »
SQL Server Case Statement syntax
On 14th Aug, 07 | Topic:
SQL Server
| Tags:
syntax
SELECT title, price,
Budget = CASE price
WHEN price > 20.00 THEN 'Expensive'
WHEN price BETWEEN 10.00 AND 19.99 THEN 'Moderate'
WHEN price < 10.00 THEN 'Inexpensive'
ELSE 'Unknown'
END,
FROM titles
« previous | next »