在MSSQL中将数字转换成中文
时间：2021-07-01 10:21:17
帮助过：13人阅读
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中将数字转换成中文
标签：
