Removing characters out of a field

[julball]

I have a search screen and the user will be entering an isbn number to search.
Some users will enter dashes and others will not. My database field has dashes.
What I would like to see happen is that the data can be found whether a user
enters dashes or not.

[eastinq]

That is going to be hard to do, since the dashes may not be in the same
position in any given ISBN number. What about adding a second ISBN number
without the dashes in your database that is just used for searching? When the
user enters a number, just remove any dashes and compare with the ISBN search
version.

You could use LIKE for partial numbers.

WHERE ISBN_Searchable LIKE '%#Replace(FORM.ISBN,"-","","all")#%'