mysql 函数 人民币大写_sql 数字转人民币大写函数(两种方法)

create function UpperRMB(@num numeric(14,2))returns @rmb table(

亿varchar(2)

,仟万varchar(2)

,佰万varchar(2)

,拾万varchar(2)

,万varchar(2)

,仟varchar(2)

,佰varchar(2)

,拾varchar(2)

,元varchar(2)

,角varchar(2)

,分varchar(2))as

begin

insert into @rmb

select(case亿1when 0 then '零'

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) as亿,

(case仟万1when 0 then '零'

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) as仟万,

(case佰万1when 0 then '零'

when 1 then '壹'

when 2 then '贰'

when 3 then '叁'

when 4 then '肆'