Pattern matching a line ending character

Hi, I think I have managed to get a line ending character in some of my text
fields. If I do a select I get this:

array_design_id | gene_identifier | control_name
-----------------+---------------------------+-------------------
10 | SC-Calibration_10 (13F24) | SC-Calibration_10
10 | SC-Calibration_10 (13E24) | SC-Calibration_10
8 | SC-Calibration_10 (9H17)
| SC-Calibration_10
8 | SC-Calibration_10 (9G17)
| SC-Calibration_10

So I think in some cases the gene_identifier has a line ending character, I
am trying to select on it, but cannot seem to find the right syntax:

select * from array_scheme where gene_identifier like '%\\r';

And have tried various combinations of \\r\\f, \\f\\r, \\f, \\n etc....
Anybody have any ideas of what I may be doing wrong... Or what maybe going
on here?

Thanks for any help

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.