I'm essentially done with a little project I've been working on and I have just one thing that isn't quite working like I'd hoped.
I have a search that gets run from a drop down selection (using a jumpmenu....my way of filtering thru the SQL DB) and I'm not getting the specific search result that I want. I'd like to have my search string look for an exact match to a recordset, whether it be using quotes (not working) or some other way.
Here's some of the code I'm using:
...and so onCode:<option value=search.asp?searchTerm=Level1&Submit=Search>1</option> <option value=search.asp?searchTerm=Level2&Submit=Search>2</option>
The above line of code is one of many items that appear in a drop down menu, so when you select this item "1" it is searching the SQL DB for the term "Level1". However, when it does this, it also returns other items like "Level11" or anything else that has a number "1" in it. So rather than getting just the actual records for "Level1" it returns "Level14", Level10"...etc.
Is there a way I can structure this search term to look for an exact term, "Level1" and only get the recordsets that are just "Level1"?
Thanks in advance!