General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
MTON is what did it. I ended up posting the question on the SBT Loop since everyone was caught up in the MVP madness here.
Thanks,
Michelle
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only