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
.