I don't understand how mod will work.
I tried to use (substring,1,6) (substring,7,2)
But being it is a double I can't use substring.
I don't understand how I can use my SQL to grab the cents.
With out checking the length like
can you get me closer. Its not a
string so above won't work. But that is the way I am thinking I will have to go.
Thank you in advance
Justin