在MSSQL中将数字转换成中文

具体代码如下：

CREATE FUNCTION [dbo].[fn_NumberToChinese] (@number INT)
RETURNS VARCHAR(20)
AS
    BEGIN
        DECLARE @res VARCHAR(20);
        DECLARE @str VARCHAR(10);
        DECLARE @char CHAR(1);
        SET @res = '';
        SET @str = CAST(@number AS VARCHAR);
        SET @char = SUBSTRING(@str, 1, 1);
        SELECT  @res = ( CASE ( CAST(@char AS INT) )
                           WHEN 1 THEN '一'
                           WHEN 2 THEN '二'
                           WHEN 3 THEN '三'
                           WHEN 4 THEN '四'
                           WHEN 5 THEN '五'
                           WHEN 6 THEN '六'
                           WHEN 7 THEN '七'
                           WHEN 8 THEN '八'
                           WHEN 9 THEN '九'
                           ELSE '零'
                         END );
        IF ( LEN(@str) > 1 )
            BEGIN
                SELECT  @res = @res + ( CASE LEN(@str)
                                          WHEN 2 THEN '十'
                                          WHEN 3 THEN '百'
                                          WHEN 4 THEN '千'
                                          WHEN 5 THEN '万'
                                          WHEN 6 THEN '十'
                                          WHEN 7 THEN '百'
                                          ELSE ''
                                        END );
                SET @res = @res
                    + dbo.fn_NumberToChinese(CAST(SUBSTRING(@str, 2,
                                                              LEN(@str) - 1) AS INT));
            END;
        RETURN @res; 
END;

使用：

SELECT dbo.fn_NumberToChinese('21')

结果：

　　二十一

转载于:https://www.cnblogs.com/zuqing/p/4564619.html