I have a table called pnltemp. The store column is defined as CHAR(4). I am wanting to scan through the entire table and strip off the leading character. I am using the following code, but for some reason it is not working properly (does it for maybe 4 of the 70 entries):


SELECT pnltemp
SCAN
store2 = substr(alltrim(store),2,3)
REPLACE store with store2
ENDSCAN



PLEASE HELP!!!!