Hi, getoffmyfoot

can you tell me what more details you would like to know

thank you

i want the one which has the values on all rows

3 c N 653 12 3,935 4,493 2,293

Thanks to all for the help.......

declare @x decimal(10, 4)

set @x = 3.4567

select @x, cast(@x as decimal(10, 1))

no matter how big is the number i want first 2 digits

i have a row of data with numbres like 1.43467,..,... and i want a sql code that can make it 1.4