如题所述
第1个回答 2009-12-03
方法一：
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
这是网上查的。呵呵本回答被提问者采纳
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
这是网上查的。呵呵本回答被提问者采纳
