数字转换大写 sql 语句

2010-09-16 09:52:00

数字转换大写 sql 语句

求一个把用户输入的数字转换为大字的存储过程。 #2楼 得分：0回复于：2007-11-07 12:09:42

SQL code

declare @source varchar(32), @result varchar(32)set @source='123456789'set @result = replace(@source,'0','零')set @result = replace(@result,'1','壹')set @result = replace(@result,'2','贰')set @result = replace(@result,'3','叁')set @result = replace(@result,'4','肆')set @result = replace(@result,'5','伍')set @result = replace(@result,'6','陆')set @result = replace(@result,'7','柒')set @result = replace(@result,'8','捌')set @result = replace(@result,'9','玖')select @source,@result

/*-------------------------------- --------------------------------123456789 壹贰叁肆伍陆柒捌玖(1 row(s) affected)*/

SQL code

replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace( - - - - - - - - - - - - - - > replace(i,0,'零') - - - - - - - - - > ,1,'壹') - - - - - - - - - - - - - - > ,2,'贰') - - - - - - - - - - - - - - > ,3,'叁') - - - - - - - - - - - - - - > ,4,'肆') - - - - - - - - - - - - - - > ,5,'伍') - - - - - - - - - - - - - - > ,6,'陆') - - - - - - - - - - - - - - > ,7,'柒') - - - - - - - - - - - - - - > ,8,'捌') - - - - - - - - - - - - - - >,9,'玖') - - - - - - - - - - - - - - >