CONVERT Money Char(20)  
Author Message
dmantanona





PostPosted: Top

SQL Server >> CONVERT Money Char(20)

I have a sql query listed below that I would like to only output values like
'6024', the Bonus values are converted to char(20) from Call_Movement table.


SELECT cast(cast(Bonus as money) as char(20)) like = '6024' from
Call_Movement
where DATEDIFF(mi, Start_Time, GETDATE()) <=60

Please help me complete this task.

SQL Server201