Using Instring Function?
Posted on 2006-06-14
I have a column that is prefilled with zeros. The column has a length of 15. What I need to do is join it to another column that isn't prefilled with zeros. My thought is that I need to change the column that is prefilled with zeros.
How do I do this? Please provide the code. Thanks a lot!
***Ignore this part below, unless you need a method to do this***
It may work like this,
Instring for first non-zero character from the left side. Then take this result and subtract it from 15. Then use this result in a right function to determine how many charachters from the right side to use.