Re: Informix stored procedure

Posted in 1995

CRAIG@CHEMISTRY.CHEM.UTAH.EDU — 25 Aug 1995 11:13:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Peter, Regarding > > No doubt SPL doesn't support CLIPPED either, but it probably won't matter. > As shocking as it may seem, there is a clip function in Informix's stored procedures. It's actually called TRIM() and can be used in stored procedures or in SQL statements (e.g. SELECT TRIM(a) || TRIM(b)...). I know that the function/expression exists in OnLine 7.1 but it may have been introduced as early as version 6. Most people aren't aware of its existence though because it's only documented in the latest SQL manuals (labeled version 7.1). --Craig (craig@chemistry.utah.edu)