Re: Clipped statement in Stored Procedures

Posted in 1998

Art S. Kagel — Mon, 31 Aug 1998 14:11:44 -0400 — source: Informix-list mailing list archive (1991-1998)

Alexey Smirnov wrote: > > Does anyone know if there is an anology to the "clipped" statement in > the Stored Procedure Language? You can use the SQL TRIM function: TRIM( string ) Trim all leading & trailing spaces TRIM( BOTH FROM string ) Trim all leading & trailing spaces TRIM( LEADING FROM string ) Trim leading spaces TRIM( TRAILING FROM string ) Trim trailing spaces TRIM( LEADING "$" FROM string ) Trim leading dollar signs ("$") etc. Art S. Kagel