REGEX search for whole line

[erne]

you're the most welcome! :-)



on 22-06-2007 13:20, jda at jda at his.com wrote:

>> Hello Jon,
>> 
>> take a look at this:
>> 
>> (?m)    Caret and dollar match after and before newlines for the remainder
>> of the regular expression. (Older regex flavors may apply this to the entire
>> regex.)
>> 
>> from:
>> 
>> http://www.regular-expressions.info/reference.html
>> 
>> so maybe try:
>> WHERE fld REGEX '(?m)^second line$'
>> 
> 
> Hi erne, thanks! So far, that seems to work. I'll do more testing,
> this may in fact be the solution.
> 
> Thanks again,
> 
> Jon
> _______________________________________________


Cool Runnings,
Erne.
-- 

/ |\ |\  | /
­ |/ | \ | ­
\ |\ |  \| \