hi
how to remove leading zero's in a column like 0000145678 and want remove 4 zero's and some times if it has 5 zero or 3
pls advise
thank you
Printable View
hi
how to remove leading zero's in a column like 0000145678 and want remove 4 zero's and some times if it has 5 zero or 3
pls advise
thank you
LTrim('000123','0')
thanks..intially i didn't palce myvalue in quotes ..that was problem
thanks...