How can I convert this Excel formula to an Access query?

[cliff.clayman]

I have a formula in Excel that I would like to know how it can be converted to be done in an Access query instead.

The Excel formula is:

=ISNUMBER(SEARCH(B1,A1))



I am checking to see if the value of B1 exists in A1. Is there an Access function that does that same thing?

[pbaldy]

I haven't used the SEARCH() function in Excel, but it sounds like the InStr() function in Access. IsNumeric() is probably the Access equivalent of ISNUMBER()

[ItsMe]

I wonder if an IIf() function would be useful. Maybe add some wildcards. Just a wild guess, though.
IIf(Column1 = Column2, "Yes", "No")
https://msdn.microsoft.com/en-us/lib.../gg264412.aspx

[cliff.clayman]

I don't want to know if the columns match, I need to know if a value from one field exists in another. For example:
Full Name
John Smith

Last Name
Smith

I want to compare the Last Name field with the Full Name field to see if "Smith" is in both.

[pbaldy]

Did you try InStr()?

[cliff.clayman]

I don't want to extract anything; I want to compare two fields.

[ItsMe]

I don't want to extract anything; I want to compare two fields.

Here is a reference
https://msdn.microsoft.com/EN-US/lib.../gg264811.aspx

[CJ_London]

use the instr function which is similar to the excel Search function (note the strings are the other way round), but returns 0 if not found rather than #Value, so you don't need the isnumeric function

=instr("ABCDE","C") will return 3
=instr("ABCDE","Z") will return 0

so instr("ABCDE","C")=0 will return false

[cliff.clayman]

Yes, that worked! Thank you.