var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Select 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.
If it's not practically useful, then it's practically useless.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors