Hi All I need some help, this is my first post.
I have this: 3416.65
I need to end up with this: 0341665
What I get when I try to cast(amount as Char(7)) is 3417
I can't figure out how to stop the rounding, I've tried varchar etc...
I'm ok with casting the left zeros, but how can I make the number appear correctly in my fixed file format.
Thanks, John B