Comparing a text string.

[hooi]

Hi,

I'm having problem in trying to create a query to display records:

Eg. If I have a field with the following three records:
john@abc.com
ben@def.com; cathy@ghi.com
cathy@ghi.com

If I want to pick up records containing text "cathy@efg.com", the 2nd and 3rd records should be retrieved. However, when I tried:

In ("cathy@ghi.com") or
Like ("cathy@ghi.com")

both of them are retrieving only the 3rd record.

What statement should I use?

Thanks for helping...

 

[Oldsoftboss]

Something like this perhaps?
HTH
Dave

 

[hooi]

Well... Thanks man. Truly appreciate your help Dave.
Have a nice day.

 

[hooi]

Hi Dave,

Is it possible to achieve the same thing from a query?

Thanks...

 

[hooi]

Got it. the criteria for the query is as follows:

Like "*cathy@ghi.com*"

Thanks for helping...

 

[Oldsoftboss]

Or... Like "*" & Forms!YourFormName!TextboxName & "*"

Dave

 

[hooi]

Got it. Thanks Dave...