Int Field not Outputting Decimal Point

[JDTurk]

When viewing a payroll record on a GUI screen, amt09(int, Null) is displayed as 61.77. When I output the data using SQL, the amount is 6177. How can I get the decimal point to appear? Thank you.

S8730 Processors (Redundncy/Mirror Img)
Aura 5.2 (Communication Manager)
Modular Messaging 5.2

 

[gmmastros]

divide by 100.00

Select amt09 / 100.00
From yourtable

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[JDTurk]

Thanks George. Any way I can shorten the number of decimal places to two?

S8730 Processors (Redundncy/Mirror Img)
Aura 5.2 (Communication Manager)
Modular Messaging 5.2

 

[gmmastros]

Select Convert(Decimal(10,2), amt09 / 100.00)
From yourtable

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[JDTurk]

Perfect! Thanks George. Happy holidays!

S8730 Processors (Redundncy/Mirror Img)
Aura 5.2 (Communication Manager)
Modular Messaging 5.2