>My main question is regarding a keyword that will return .t. if a substring exists in another string. I found the command strtran but this would replace the substring with another string.
>
>I am trying to come up with a peice of code that will return a subset of all records in a table that a particular word occurs in one or more fields.
>
>Thanks,
>Paul

Select fields from mytable where somefied like '%string_here%'

Locate for "string_here" $some_field

You can also include upper() for case insensitive searches