学步园

将整型数字转换为大写汉字的自定义函数,如转换为'壹贰

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)