REGEX question

[jda]

>  >>>  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'
>  >>
>
>  > and it finds the text.
>
>I think you should do
>
>     REGEX '\Aruslan.pdf\Z'
>

I thought that, too, but it doesn't work. Here is what works so far:

REGEX '(?i)[\r\t]ruslan.pdf

This finds only lines beginning with ruslan.pdf

But I can't get the end-of-line to work if it's the last character in 
the field. I thought this would work:

'[\r\t]ruslan.pdf\Z'

but it doesn't (I get no hits if I include the \Z).

Jon