Case in Sql

18Fev09

This example shows the use of CASE in SQL.

select case gender when ‘M’ then ‘Male’
when ‘F’ then ‘Female’
else ‘Other’ end
from users

Works in Sql Server and Sybase.

Filed under: Sql   |  Leave a Comment
Tags: ase, case, else, end, example, mssql, sample, Select, Server, Sql, Sybase, T-Sql, then, when