Re: Trimming strings in SQL

Posted in 1998

Leonid Belov — Fri, 30 Oct 1998 16:42:11 -0300 — source: Informix-list mailing list archive (1991-1998)

Darrel Davis wrote: > Does Informix SQL have any comparable commands > like Oracle's LTRIM and RTRIM? Is there another > way to get trimmed strings is SQL. I know about > 'clipped' in 4GL but we need to be able to do it > in SQL. > > TIA, > -darrel > TRIM(LEADING FROM string_value) TRIM(TRAILING FROM string_value) TRIM(BOTH FROM string_value) == TRIM(string_value) You can also trim given number of blanks: TRIM(Leading 15 FROM s) Hope this helps Leonid