Re: Remove Whitespace

Posted in 2004

Mark D. Stock — Wed, 24 Mar 2004 23:00:34 +0000 — source: Usenet: comp.databases.informix

Phillips, Rob wrote: > What is the function to remove leading and trailing whitespace > characters from a field. Similar to Ltrim & Rtrim in MSSQL. The TRIM() function. It will trim LEADING, TRAILING and BOTH. BOTH is the default. Full syntax in TFM. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list