Data Conversion

How do I convert 0.50 to 50 or 0.1429 to 14.29 in sql query? M开发者_Python百科y data type is real.

Multiply by 100.

You can multiply it by 100. : )

I'm not sure exactly what you are doing, but it's like this:

Select 0.50 *100 as MyNewNumber

or

Select MyColumn *100 as MyNewNumber

SELECT (column * 100) FROM TABLE

:)

select 0.50*100

in sort

SELECT (data * 100) 

SELECT u.`value`*100 FROM invoice