I want to find all rows with a '\n' in a varchar column:

where message_text like '%\n%' does not work as the backslash is not
being interpreted literally.

It does not find 'following error:\n%s.'

using lile '%[\n%' escape '[' does not work as a backslash can not be
escaped:

E_AD1018 Illegal pattern match specified: Illegal ESCAPE sequence.
The ESCAPE char must be followed by one of:
`%' (percent)
`_' (underscore)
`[' (left square bracket)
`]' (right square bracket)
another ESCAPE char.

using like '%\\n%' also doesn't work ...

I'm all out of ideas - Help !

<colinhay66 (AT) hotmail (DOT) com> wrote

You are looking for an ASCII 0x5C followed by ASCII 0x6E right? Not ASCII
0x0A? If so, what you are doing works for me. In Windows and Unix.

Roy

"Roy Hann" <specially (AT) processed (DOT) almost.meat> wrote

Of course, if you DID mean 0x0A, then LIKE x'250A25' should do it for you.

Roy