REGEX search for whole line

[jda]

>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