有些变态的报表需要把数字转换成英文输出,但愿这个能帮得到你 one hundred eighty-eight thousand, eight hundred one hundred eighty-eight thousand, eight hundred one one hundred eighty-eight thousand, eight hundred two ... one hundred eighty-eight thousand, eight hundred nine one hu
代码如下:Alter Function UDF_Util_ConvertCurrencyToEnglish ( Money Numeric(15,2), Unit varchar(10)=’BAHT’ ) Returns Varchar(400) As /* /// /// Convert money to english /// /// e.g. 1234.56 /// e.g. ‘BAHT’ /// engli