I have been using this to see if a sample string is in the target string
InStr(1, UCase(strNames), UCase(TestString), vbTextCompare)
but without realizing it I have a bigger problem now ... sometimes I have similar strings and the return value is true when I expect false .. for example when "ID1" is the test string and "ID10" is already in the string ...
I'd like to have a better method of doing the comparison, but it needs to be efficient.
I'll take any suggestions