Quote:
Originally posted by mpedrummer2
Hmm...perhaps I'm unclear...
I want the user to be able to search for the specific 6648-84U and have a record MATCH 6648-8%. So the user could enter any specific model number, and match the broader information as well.
Without entering everything as individual keywords.
MPEDrummer
|
Well, here you get the problem of not knowing where to cut off the search and put in the %. If there's a clear way to know where to cut it, then just chop that bit off and add in the %. For example, if you always want to cut off the last 2 digits, or if you always cut starting from the last number, etc. If there isn't a clear way to cut it, you'd need to specify specific rules depending on the type of id. This could be very, very tedious. It might be better to just leave that kind of searching to the user - they probably know better than the program anyway.