Remove Whitespace

Posted in 2004

Phillips, Rob — Wed, 24 Mar 2004 11:49:24 -0500 — source: Usenet: comp.databases.informix

What is the function to remove leading and trailing whitespace characters from a field. Similar to Ltrim & Rtrim in MSSQL. sending to informix-list

↪ replying to Phillips, Rob

Jay Aymond — Wed, 24 Mar 2004 12:10:24 -0600 — source: Usenet: comp.databases.informix

ltrim, rtrim, trim. "Phillips, Rob" <RPhillips@ce-a.com> wrote in message news:c3sfk6$jim$1@terabinaries.xmission.com... > > What is the function to remove leading and trailing whitespace > characters from a field. Similar to Ltrim & Rtrim in MSSQL. > > > sending to informix-list