>Hi. I want to be able to search my dbf (free) from a form with the "dashes, slashes and blanks" removed (for a more thourough Find).
>
>I am using the following on both my search criteria and the index for my database
>
CHRTRAN(itemno,'/- ','')
>with NO favorable results. Can someone tell me what I am doing wrong (or an article/example)?? I am using a SEEK. Should I be using SQL?
>
>Thanks, Randy
>ps: I am still in Fox 7.
Sorry, but as long as I know you can't use CHRTRAN() for "searching" records and less on an index key...
You must find using AT() or similar and then you can replace what you want using STRTRAN()
Now I'd really like to know what happen if you use CHRTRAN() on an index key.