You might also want to check out the MTON() and NTOM() functions.
Evan
>I have an SQL SELECT that produces a Y and a N(14,0). I want to divide the Y by the N, but it keeps telling me "currency value is out of range". I even tried ROUND(amount/netwgt,2) but it doesn't like that, either.
>
>Any ideas?
>
>Thanks,
>
>Michelle
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?