Showing posts with label pleasewhen. Show all posts
Showing posts with label pleasewhen. Show all posts

Monday, March 19, 2012

How to Change 200 to 2.00

Hi,
Can anyone help me on this problem please?
When i use sql statement to pull out data, one of the fields will pull out data like 200 or 300 or sumthing like that.
But now i need to pull out the data as 2.00 instead of 200.
How do i do that?
ThanxSelect Cast(200/100 As Decimal(38, 2))|||The simplest way to turn 200 into 2.00 is to invest it in AT&T stock.

Barring that, why don't you just divide by 100.00? Note that you will need to include the decimal point and placeholders in your divisor so that the result will include 2 digits of precision.