search for records

W

WRC

I need to find a way to search for records, in the list fo 3,000 item numbers
in one column:

1. Have only one character different from a given search string.
2. The different character can be at any position on the string of the
records found.
3. If none of the records have one character different from the given
string, search for records have two characters different from the search
string.
4. If none of the records have two characters different from the given
string, search for records have three characters different from the search
string.
5. If none of the records have three characters different from the given
string, search for records have four characters different from the search
string.
6. If none of the records have four characters different from the given
string, search for records have five characters different from the search
string.
7. If none of the records have five characters different from the given
string, search for records have six characters different from the search
string.
8. If none of the records have six characters different from the given
string, search for records have seven characters different from the search
string.
9. If none of the records have seven characters different from the given
string, search for records have eight characters different from the search
string.



Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top