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