Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Just "00000" was not giving expected results.
What result was given?
Did you try the suggestion from dbz? When you try it, make sure to use the required number of zeros (as dbz did). An implied decimal should cause no problem.
This has hit performance
How was this measured? It appears that the most costly way to do the job was chosen. If this is a one-time process, probably not an issue. If this is part of some regular run, and you can actually see a performance hit, it would probably one a good idea to change the process.