REGEX search for whole line

[Ruslan Zasukhin]

On 21/6/07 5:20 PM, "jda" <jda at his.com> wrote:

Hi Jon,
 
> I'm trying to do a REGEX search for a word or phrase that occupies an
> entire line. For example, finding "second line" in this field:
> 
> first line
> second line
> third line
> 
>  From the ICU docs it looks like this should work
> 
>   ...WHERE REGEX '^second line$'

Yes seems correct.
 
> but it doesn't (it works if the only words in the field are 'second line').
> 
> What would be the correct syntax?

Does your field is indexed by words ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]