I would like to limit my search results in the following way:

1. I would like to be able for users to be able to put parts of words in the text box fields so that they can, for instance, search on "Jane" and get "Jane," "Janet" and "Janelle." They can of course do this be default, except....

2. I would like to limit the search fields that have selection boxes/radio buttons/checkboxes to search *only* for the exact word. For instance, I would like a search on "Clerical Specialist I" to return only that position and not also "Clerical Specialist II" and "Clerical Specialist III."

Is this differentiation possible?

Thanks to all of you who help out around here :)

Elizabeth

I would highly suggest setting up a custom search form.

By doing so you could have your dropdown lists only display the actual field contents from which to choose from. For example:

<TR><TD><$font>Year:</font></TD><TD>|; print &build_select_field_from_db("Year",$rec{'Year'}); print qq|</TD></TR>

Check out the FAQ noted below under the section "Searching" and you will find examples. You could also provide a choice of using the keyword or advanced/custom search form. There are instructions for this type of setup also in the FAQ.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/