Friday, April 11, 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
By at
Tags

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )
AJAX, asp, Asp.net, asp.net and sql server security, Asp.net IntemIndex, C#, Css, DataBinder.Eval, DataKeyNames, Datalist, Datapager, DataSet, DataTable, DropDownList, FindControl, gridview, JavaScript, jquery, Listview, Paging, Regex, RegularExpression, Repeater, Server side validation, Sql Server, timer, timercallback, Validation, XML, xmlnode, XPath