方法一:
select (case TitleOfCourtesy when 'Ms.' then '女士' when 'Mr.' then '男士' else '' end) as TitleOfCourtesy from dbo.Employees
方法二:
select (case when TitleOfCourtesy = 'Ms.' then '女士' when TitleOfCourtesy = 'Mr.' then '男士' else '' end) as TitleOfCourtesy from dbo.Employees
注意如果要判断是否为null只能用第二种方法判断,第一种不行,会报错,如下面语句中的:TitleOfCourtesy is null
select (case when TitleOfCourtesy is null then null when else '' end) as TitleOfCourtesy from dbo.Employees