General information
Category:
Coding, syntax & commands
Title:
SQL Select with CharTran()
Hi. VFP6 - sp5. I have a database and the end-users have put the dashes in different places in the data (over the years). Example: 303-00, 30-300,3-0300. I want to use chrtran in my sql select, but the following doesn't seem to work:
SELE * FROM mytable WHERE chrtran(myfield,'-','') = chrtran(This.Value,'-','')
The reason for the "trash" data is because several of our vendors have changed the formatting of their item numbers as they have migrated to new computers.
Thanks, Randy
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