sql替换小数点之后的数字为英文

 

 

 

 

 

SELECT CONVERT_TO_DOLLAR,SUBSTRING(CONVERT_TO_DOLLAR ,CHARINDEX('.',CONVERT_TO_DOLLAR)+1 ,len(CONVERT_TO_DOLLAR)-charindex('.',CONVERT_TO_DOLLAR) ) ,
replace(replace(REPLACE( SUBSTRING(CONVERT_TO_DOLLAR ,CHARINDEX('.',CONVERT_TO_DOLLAR)+1 ,len(CONVERT_TO_DOLLAR)-charindex('.',CONVERT_TO_DOLLAR) ) , '0' , 'ZERO'), '1', 'ONE'), '2', 'TWO')
FROM CMS.DBO.BAS_IMG_EXCHANGE_RATE