Pages - Menu
(Move to ...)
Home
About Us
Contact Us
▼
Friday, 11 April 2008
display custum text using case in sqlserver
SELECT FirstName, LastName,
CASE WHEN sex ='M' THEN 'MALE'
WHEN sex = 'F' THEN 'FEMALE'
ELSE 'Undefined'
END As Sex
FROM Employees
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment