在MSSQL中将数字转换成中文

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‘)

结果：

　　二十一

在MSSQL中将数字转换成中文

标签：

本文系统来源：http://www.cnblogs.com/zuqing/p/4564619.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！