convert a number to decimal

Question

convert a number to decimal

Faye Fouladi

SSCrazy

Points: 2770
More actions
January 26, 2010 at 11:52 am

#214887

Suppose:
Declare @mynumber int
Set @mynumber = 10299
How can I return 102.99 from this or if the variable will be given at runtime, how can I process it to return a number with the first two digits being the decimal.

Viewing 3 posts - 1 through 2 (of 2 total)

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

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 1

Faye Fouladi (1/26/2010)
Suppose:
Declare @mynumber int
Set @mynumber = 10299
How can I return 102.99 from this or if the variable will be given at runtime, how can I process it to return a number with the first two digits being the decimal.

The same way you'd do it manually. Divide by 100.0.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Faye Fouladi (1/26/2010)
Suppose:
Declare @mynumber int
Set @mynumber = 10299
How can I return 102.99 from this or if the variable will be given at runtime, how can I process it to return a number with the first two digits being the decimal.

As Jeff said:

select @mynumber / 100.0