I want to cast an In to varchar with a specific number of decimal places. So 10 will come across as 10.00.
Is there an easy way of doing this?Would you be llooking for something like this?
Code:
------------------------------
select cast(cast(10 as money) as varchar(10))
select cast(cast(10 as numeric(12,4)) as varchar(10))
------------------------------|||I think this is what Paul was trying to show:
select cast(cast(id as decimal(5,2)) as varchar(10)) from table
Where id and table are defined by you. The decimal parameters would be determined by your maximum integer.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment