Is there a function can I use for this type of problem

First, I have to search for a particular string.

   sComp = "Company list, The"

I want to search for a string ", The"

I used
   nPos = InStr(sComp , ", The")

My question is, sometimes the sComp = "Company list, THE"
and sComp = "Company list, ThE"


Thanks,
Elmer

Make a compare using vbTextCompare. It will search the string ignoring the case.

nPos = InStr(sComp , ", the", vbTextCompare)

Stéphane Lajoie

Thanks it works Stéphane Lajoie

what if my sComp = "33 Anywhere st. Nowhere Ave."
               and "33 Anywhere Street. Nowhere Avenue"

what should be my search string to get both the sComp

nPos2 = InStr(1, sLine, "?", vbTextCompare)

Thanks,
Elmer

hi..

then you will have to use something like this..

if scomp like "33 Anywhere st*. Nowhere Ave" then

b/c you are not interested in the case, add lcase() to both strings...

HTH

Gonzalo