I am building a flat file for upload to a vendor. This file should contain no decimal points or periods. My results currently contain a decimal point in the money and a period after the middle initial of the name. I am using cast on the ckhcunetpay field as this returns two decimal places instead of four. In both cases there is data before and after the dot.
How can I remove the dot.
'000000' as start,
'011111111111111100000' as space1,
cast (ckhcurnetpay as char) as amount,
ckhcheckno > '4177'