>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
Wow, perfect timing
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-search-for-all-words-inclusive-wieasily adaptable for VFP
If it's not broken, fix it until it is.
My Blog