Re: Trimming strings in SQL

Posted in 1998

Billy Wheeler — Fri, 30 Oct 1998 15:42:54 +0200 — source: Informix-list mailing list archive (1991-1998)

On 30 Oct 98, at 7:44, 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. Look up the TRIM command. HTH. -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________