获取汉字第一个字符的存储过程 by zhouwillpower
摘要:
Create function fun_GetPY
@str nvarchar(4000) returns nvarchar(4000)
As
begin
declare @word nchar(1),@PY nvarchar(4000)
set @PY=''
while len(@str)0
begin
set @word=left(@str,1)
--如果非汉字字符,返回原字符
set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901
then ( select top 1 PY from (
select 'A' as PY,N'驁' as word
阅读全文
posted @ 2006-06-22 16:56
zhouwillpower
阅读(193)
评论(0)
推荐(0)
浙公网安备 33010602011771号