将整型数字转换为大写汉字的自定义函数,如转换为'壹贰
闲话不说直接上代码
CREATEFUNCTION [dbo].[f_digit_chn](@num bigint)
RETURNSvarchar(20)
AS
BEGIN
DECLARE @result varchar(20),@symbol varchar(2)
IF @num<0
SELECT @symbol='负',@result='',@num=ABS(@num)
ELSE
SELECT @symbol='',@result=''
WHILE @num<>0
SELECT @result=(SUBSTRING('零壹贰叁肆伍陆柒捌玖拾',((@num + 1)%10),1) + @result),@num=@num/10
RETURN @symbol + ' ' + @result
END
-- 调用select dbo.[f_digit_chn](12345678)
转载于:https://blog.51cto.com/346832171/989424