If Statement with Like - Help... 1

[Basia]

I am trying to set up an if statement using "like."

Here is the If:

If varTitle = "Manager" then
process
End If

How do I make sure that anyone who has Manager in their title gets processed? Would it be the same for a Select Statement?

Any help is much appreciated!
Basia

 

[xlbo]

Try this
If varTitle = "*Manager*" then
process
End If

I believe that in some forms of SQL, you have to use the % as the wildcard
HTH
Geoff

 

[Basia]

Thanks for you quick response. I have tried the wild cards **, but it still does not catch the records. Any other thoughts?

Basia

 

[xlbo]

Sorry - use the LIKE keyword
If varTitle LIKE "*manager*" then
process
etc etc
HTH
Geoff

 

[Basia]

Works perfectly!

Thank you so much!!!

Basia