newbie question

[hollister]

We have a simple products database. We do a lot of searches by product name. Here is an example.

Name: Panasonic AYDVM83MQ

If I do a search for " 83MQ " I get an error stating "No records match this request"

This happens for all sorts of searches. It will find it if i search for "AYDVM83MQ" but no one is going to remember that much of the name. Is this a fault in the database? It seems that it should find it.

Any help would be great. thank you.

[stanley]

Hollister:

Welcome to the Forums. You need to insert wildcards into your searches. If you search for "*83MQ*" it will find what you're looking for. You can script your find so that the stars are added to what the user enters, or you can just let the user know about the syntax.

-Stanley

[hollister]

DOH! my goodness. why did I not think of that. I so much associate * with the command line. OMG! thank you very much.