Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Power() usage?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00561544
Message ID:
00561591
Views:
25
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform