POWER() function return type is the same as it's first parameter
SELECT 2 * cast ( POWER(<b>10.000</b>, -2) as dec(9,3) ) as total
>I am normalizing FoxPro data for a DW. I have 2 columns a
>value and an exponent. In the DW I need to create the
>real #.
>
>SELECT 2 * cast ( POWER(10, -2) as dec(9,3) ) as total
>GO
>
>
>returns .000
>
>The # 2 is my value and the -2 is my exponent.
>
>How do I get a .02 or .020 as a return?
>
>__Stephen
>.
--sb--