display custum text using case in sqlserver Written by Suresh Sharma on April 11, 2008 in Sql Server with No comments SELECT FirstName, LastName, CASE WHEN sex ='M' THEN 'MALE' WHEN sex = 'F' THEN 'FEMALE' ELSE 'Undefined' END As SexFROM Employees Share: Email ThisBlogThis!Share to XShare to Facebook
0 Comments:
Post a Comment