Displaying Currency without the Decimal in SQL
Posted on 2012-03-13
I have a Column in a Table that has Currency input into it. I need to display this Currency as part of a String without the Decimal.
How do I go about doing this?
This is what I have thus far
SELECT '0000012345678901'+LTRIM(CAST(ITEMNO AS VARCHAR(20)))+''+CAST(checknet AS VARCHAR(20))+''+CONVERT(varchar(10),checkdt, 112)+CASE(ckstatus)
WHEN 'O' THEN '' WHEN 'V' THEN 'C' END +'' as Val
Where you see +CAST(checknet AS VARCHAR(20)) is where I need to extract the information from that Column and display it without the Decimal.