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
Peter Cortiel