Anyone know the best way to get:

? VAL("3,000.99")

which returns a numeric 3.00

to return a numeric 3000.99 (or even 3,000.99) ?

I am needing to replace thousands of character numbers found in a character type field to numeric fields.

Thanks in advance...