Locating Carriage Return Character In String

Posted in 1999

Cook, Russell L — Fri, 20 Aug 1999 07:46:54 -0700 — source: Informix-list mailing list archive (1991-1998)

What is the technique for finding an embedded carriage return character in a particular field via a SQL query? I need to locate these <cr> that exists randomly in my data and remove them. My thoughts are using an update query of come kind. Appreciate all of your help. Thanks in advance. Russ Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc