Thread: Using InStr Function

Hello,

I have a variable which holds a value.

str="Student Deposit: Session 123"

If the str variable has the word Student Deposit I want to display a message

So i used the Instr function but it didnt work out.

How can I search in str variable that it holds the words Student Deposit.

todd

hey todd,

i think maybe like this in your where clause:

str="Student Deposit: Session 123"

try:

str="%Student Deposit%"