REGEX question

[jda]

>On 7/9/06 7:37 PM, "jda" <jda at his.com> wrote:
>
>Hi Jon,
>
>>  I'm trying to do a search on a VarCharField that will match file names.
>>
>>  The names are kept in a CR-delimited list that begins with a tab:
>>
>>  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.

Jon