REGEX question

[Ruslan Zasukhin]

On 7/9/06 8:54 PM, "jda" <jda at his.com> wrote:

>>> 
>>>  tab
>>>  file1 return
>>>  file2 return
>>>  file3
>>> 
>>>  I'm doing a REGEX search that should find ONLY complete matches. I
>>>  can match the beginning, but so far can't find a pattern that matches
>>>  the end. Here's what I have:
>>> 
>>>  select * from theTable WHERE varCharField REGEX '(?i)[\t|\r]ruslan.pdf'
>> 
>> Why regex starts from \t  \r   ?
> 
> Look at the list of file names above -- each name is preceeded with a
> tab (first name) or a return (every other name).
> 
> Funny, I am able to do a search with
> 
> varCharField REGEX ^'(?i)ruslan.pdf'$
> 
> and it finds the text.

I think you should do

    REGEX '\Aruslan.pdf\Z'


-- 
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]