It is possible that one had /r/n and the other just /n. I was doing the
comparison using psql.
The issue was not using LIKE and %.
I resolved the problem by removing chr(13) from both sides. So my
working query was had a where clause like this:
WHERE REPLACE(message, chr(13), '') = REPLACE('', c
You have made a wrong mistake in your SQL quary.
Your quary should be look like this.
SELECT id FROM table1 WHERE message like '%VAC153-683-685-131830-
/O.NEW.KLWX.SV.W.0022.060413T1742Z-060413T1830Z/
BULLETIN - EAS ACTIVATION REQUESTED
SEVERE THUNDERSTORM WARNING
NATIONAL WEATHER SERVICE
On 13 Apr 2006 12:20:08 -0700, Nik <[EMAIL PROTECTED]> wrote:
> I am trying to compare a large string (that has new line characters in
> it) to the contents of the text field (which also has new line
> characters in it) and it is not behaving as expected.
>
> For example I have the following record
