Is there a way for a user to search a field in an indexed database for one or more specific characters within a character string. For example, a user may want the search to return:
xxxxxxxABCDxxxxx
but NOT:
xxABCDxxxxxxxxxx
where the lowercase x is any other character?
In other words, we need to find a match for specific characters in specific places within a 16 character string, in a specific text field.
Jim Capron
Subject: Try using the mask ???ABCD???
Subject: RE: Try using the mask ???ABCD???
That should work as long as the characters matched by the question marks are alphabetic or numeric. If they are whitespace or punctuation, it wouldn’t be matched by such a search term
Subject: RE: Try using the mask ???ABCD???
Yes, this works, provided that I turn off the fuzzy search, which doesn’t make a lot of sense to me. Anyway, thanks for the quick and helpful responses.
Jim Capron