I have a website that I built, using an MS Access database. There is one field in the database called "SERIALS" this field holds all serial numbers for a specific part number. There are already thousands of records in this database, but the users would like a way to search for specific serial numbers. Is this possible? If so, how can I go about doing that? Again, the field holds 1 to dozens of different serial numbers, separated only by a single space.
I have tried
WHERE Serials = '" & Request.QueryString("serial") & "'
|
and
WHERE Serials LIKE '" & Request.QueryString("serial") & "'
|
I didn't expect either of these to work and they did not. Any ideas on how I can do this without having to create a new table and manually move all of the data over?