Searching within one string for another string

[Brad Pears]

Is there a string function that lets you specify a search string to look for
within another string and then returns the position of the start of that
string or simply returns a true/false depending on whether or not the string
I am looking for is actually in the string?

I thought I had used a function named "IsIn()" at some point in the past
although it does not seem exist in Access/VB. You simply passed it the
string you want to search and then the string you want to search for...

i.e.

this would return true... ? IsIn("Brad", "ra")
this would return false... ? IsIn("Brad", "zz")

Any help would be appreciated!!

Thanks,

brad

 

[Allen Browne]

Instr() returns a value greater than zero if the substring is found.

 

[Brad Pears]

Yes, I finally did remember this one!!!

Thanks,
Brad