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 (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 Zibo 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' ing @ n_str = '0' set @ c_data = @ c_data 'whole' Return (@c_data) End
