Create Function [DBO]. [@Num numeric (14,2)) Returns varchar (100) with encryptionasbegin - Copyright: pbsql declare @n_data varchar (20), @ c_data varchar (100), @ n_str varchar (10), @ I INT
Set @ n_data = Right (Space (14) Cast (Cast (@ Num * 100) as bigint) AS VARCHAR (20)), 14) SET @ c_data = 'set @ i = 1 while @i <= 14 Begin Set @ n_str = SubString (@ n_data, @ i, 1) if @n_str <> '' begin if not ((@ n_data, @ i, 2) = '00') OR ((@ n_str = ' 0 ') AND (@ i = 4) or (@ i = 12) or (@ i = 14)))) SET @ c_data = @ c_data substring (' zero 壹 肆 肆Wu Lu 柒捌 ', CAST (@n_str as int) 1, 1) IF not ((@ n_str =' 0 ') and (@i <> 4) and (@i <> 8) and (@i <> 12)) set @ c_data = @ c_data substring ('佰 佰 万 万 佰 圆 圆 ", @ i, 1) if Substring (@ c_data, len (@c_data) -1, 2) = 'billion' set @ c_data = substring (@ c_data, 1, len (@c_data) -1) end set @ i @ i 1 end if @num <0 set @c_data = '(negative number)' @ c_data if @ Num = 0 set @ c_data = 'zero circle' if @ n_str = '0' set @ c_data = @ c_data 'whole' Return (@c_data) endGO
