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
Share:

0 Comments:

Post a Comment