Quick Question: Carriage return

Do you know if it's possible to find carriage return in a string field in Informix database? This is for SUN 5.8 and IDS 7.31. Thanks, *************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: eknox@searshc.com <mailto:eknox@searshc.com> Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com " It's always a great day to watch Football ! " ***************************************

On Fri, May 30, 2008 at 1:18 PM, Knox, Ernest <eknox@searshc.com> wrote: > Do you know if it's possible to find carriage return in a string field > in Informix database? This is for SUN 5.8 and IDS 7.31. There was a discussion this week about ASCII and ORD (or CHR) functions in c.d.i. I pointed out that there is a package called ASCII at the IIUG web site that provides you with a function CHR(10) which could be used to help find carriage return in strings. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.