Re: Stored Procedures & removing Blanks

Posted in 1998

Jamie Nash — Fri, 10 Jul 1998 08:48:41 -0700 — source: Informix-list mailing list archive (1991-1998)

>I am writing a stored procedure which concatenates some address strings >into one string. >There are a bunch of spaces between the final string. "CLIPPED" will not >work in a stored procedure. >nore will "length" in the context w_length=LENGTH(string) and >string[1,w_length]. >What can I do to remove these spaces. > You can use..... TRIM(string) Jamie