Hi
I am querying data from sql there i want to display output with 2 decimal points .Doing like this
ex: select round(sales,2) from x

sales="12345.67789"

here i am getting 123456.68000 but i need to dispaly 123456.68 only.Sales data is not fixed length so i cant use left or right function.How to get with 2 decimal points?

try

select cast(round(sales,2,0) as decimal(Max,2)) from x
where max could be any number

hope this helps!!

Amit Jhawar
Developer

works good thanks