All content (copyright) respective authorsvmonpara's code bookmark tagged with syntaxhttp://www.codaddict.com/vmonpara/syntaxSELECT 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 titleshttp://www.codaddict.com/vmonpara/SQL ServervmonparaTue, 14 Aug 2007 04:37:50 GMT