General information
Category:
Coding, syntax & commands
Title:
Substr() not working correctly
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!!!!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only