>given that activity is a c(100) field in a table
>
>what is the bst way to find records where severeal words are present but not necessarily together
>
>eg:
>
>mouse+trap+living room
>i want to find all occurances where 'mouse' is existing as well 'trap' and 'living room'
>at the moment i have something like
>'mouse'$activity and 'trap'$ activity and 'living room'$activity
>
>which is kind of cumbersome once there are more than 3 phrases
>I hope there is a way to do that with regex???
>
>
>Thnaks
>
>
>Peter

Or just see Re: How to search for all keywords inclusive Thread #1357215 Message #1357222