How toFormat numbers?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

nrbatcha SSC Rookie Points: 42 More actions · Answer 1

Hi,

Try to do like this.

declare @no float

set @no=12

Select @no

Rafiq

Yours SQL Friend

stl7 Grasshopper Points: 18 More actions · Answer 2

but if u print it out the .0 will be missing.

print @no

I need to format my numbers to 1 decimal place.

Paul Ibison SSCertifiable Points: 5303 More actions · Answer 3

print cast(@no as decimal (10,1)) should do it.

Paul Ibison

Paul Ibison
Paul.Ibison@replicationanswers.com

stl7 Grasshopper Points: 18 More actions · Answer 4

This works but when I pass the data to ADO recordset and display on asp page, the decimal disappear again.

Does that mean that I have to do formatting in the asp code?

Steve Jones - SSC Editor SSC Guru Points: 737930 More actions · Answer 5

SSC Guru

Points: 737930

February 7, 2002 at 10:14 am

perhaps. try formatnumber()

Steve Jones

Cookies on SQLServerCentral