,@c = case chn when @chn then char(@n) else @c end
from(
select top 27 * from (
select chn = '吖'
union all select '八'
union all select '嚓'
union all select '咑'
union all select '妸'
union all select '发'
union all select '旮'
union all select '铪'
union all select '丌' --because have no 'i'
union all select '丌'
union all select '咔'
union all select '垃'
union all select '嘸'
union all select '拏'
union all select '噢'
union all select '妑'
union all select '七'
union all select '呥'
union all select '仨'
union all select '他'
union all select '屲' --no 'u'
union all select '屲' --no 'v'
union all select '屲'
union all select '夕'
union all select '丫'
union all select '帀'
union all select @chn) as a
order by chn COLLATE Chinese_PRC_CI_AS
) as b
else set @c='a'
set @return=@return+@c
end
return(@return)
end
go
调用实现查询
select * from 表 where dbo.fgetpy(字段) like 'S%'
调用函数：
----------------------------------------------------------
select * from 表名 where dbo.f_GetPy(left(字段名,1)) = 'S'
补充:sd 的话就查出 山东
调用函数：
----------------------------------------------------------
select * from 表名 where dbo.f_GetPy(字段名) like 'SD%'
如果有相关字符的话,也可以查出比如:
雁荡中队(小)
雁荡中队(大)
雁荡饭店
yd 就查出三条记录
ydzd( 就查出二条
ydzd(d 就查出一条,雁荡中队(大)
问题是我如何从中文转成拼音
|
