>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?
The seek should just work, provided you use the identical string in chrtran() as both index expression and the search expression. However, what may throw you off is the length of the term - chrtran() is removing characters and you're getting a variable length expression. Try
padr(CHRTRAN(itemno,'/- ',''), field_length)
instead.