Escapestring not escaping ^

[jda]

>Obviously you want to get something like "all records which CONTAINS
>'the' word"?

Yes.

>
>So it should be:
>select id,hit from thereferences where (allFields LIKE '%the%')
>

Thanks, I'll try that.

I looked in the RB docs and didn't see any info on this...is there 
any? I mean, docs that tell use the features of the LIKE search that 
Valentina supports?

Thanks again,

Jon