Tuesday, February 14, 2012

data format

How can I display a value as 0.00 from a field of datatype numeric?How can I display a value as 0.00 from a field of datatype numeric?
select convert(numeric(9,2),round(columnname,2)) from tablename

No comments:

Post a Comment