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
.