select ceiling(cast(replace(ltrim(rtrim(replace(substring([Text], 7, patindex('% %', substring([Text],7,20))), 'FEE', ''))), ',', '') as float)) as DBTranAmt

Leave a Reply

Your email address will not be published. Required fields are marked *