Create Function [DBO]. [@Num numeric (14, 2)) Returns varchar (100) with encryption as begin - 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 (ABS (@ 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 Zi Zi Lu 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 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) End
