SQL函数取汉字拼音首字母
2024-09-26 23:40:20
CREATE function f_GetFirstPy(@str varchar(50)='')
returns char(1)
as
begin
declare @n int, @c char(1), @chn nchar(1)
select @n=63, @chn=substring(@str,1,1)
if @chn > 'z'
if( @chn < '八' ) set @c = 'A'
else if ( @chn < '嚓' ) set @c = 'B'
else if ( @chn < '咑' ) set @c = 'C'
else if ( @chn < '妸' ) set @c = 'D'
else if ( @chn < '发' ) set @c = 'E'
else if ( @chn < '旮' ) set @c = 'F'
else if ( @chn < '铪' ) set @c = 'G'
else if ( @chn < '丌' ) set @c = 'H'
else if ( @chn < '丌' ) set @c = 'I'
else if ( @chn < '咔' ) set @c = 'J'
else if ( @chn < '垃' ) set @c = 'K'
else if ( @chn < '嘸' ) set @c = 'L'
else if ( @chn < '拏' ) set @c = 'M'
else if ( @chn < '噢' ) set @c = 'N'
else if ( @chn < '妑' ) set @c = 'O'
else if ( @chn < '七' ) set @c = 'P'
else if ( @chn < '呥' ) set @c = 'Q'
else if ( @chn < '仨' ) set @c = 'R'
else if ( @chn < '他' ) set @c = 'S'
else if ( @chn < '屲' ) set @c = 'T'
else if ( @chn < '屲' ) set @c = 'U'
else if ( @chn < '屲' ) set @c = 'V'
else if ( @chn < '夕' ) set @c = 'W'
else if ( @chn < '丫' ) set @c = 'X'
else if ( @chn < '帀' ) set @c = 'Y'
else set @c = 'Z'
else if @chn <= 'z' and @chn >= 'a'
set @c = upper(@chn)
else if @chn <= 'Z' and @chn >= 'A'
set @c = @chn
else
set @c = ''
return (@c)
end
最新文章
- Livecoding.tv 现正举行iOS及Android App设计比赛
- This build of Sublime Text 2 has expired
- Bootstrap系列 -- 11. 基础表单
- 多线程引发OutOfMemoryException
- android 瀑布流
- 单臂路由+DHCP+VLAN
- [转][Automation]- C# SendKey代码表
- 介绍几个移动web app开发框架
- Jboss基础及简单的应用
- java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
- cron expr
- JDBC连接数据库的几种方法
- 2014/08/23——OJ及相关站点打开速度非常慢,训练计划login直接error!
- 完全总结bash中的条件判断test [ [[ 使用
- Linux显示计算次数的结果
- Spring Cloud入门教程-Ribbon实现客户端负载均衡
- python day05
- HTTP协议的六种请求方法
- ssm数据库异常问题
- LB层到Real Server之间访问请求的响应时间及HTTP状态码监控及报警设置