RE: Truncation of a string

Posted in 2000

Rekaish Bhardwaj — Tue, 15 Feb 2000 17:27:10 -0000 — source: Informix-list mailing list archive (1991-1998)

I'm not sure if this is available on all versions of Informix but try SELECT TRIM(TRAILING " " from column_name) FROM table_name WHERE ..... Cheers Rekaish -----Original Message----- From: i.sokolsky@geac.com [mailto:i.sokolsky@geac.com] Sent: 15 February 2000 15:35 To: informix-list@iiug.org Subject: Truncation of a string Hi All Is that possible to truncate a string in Stored Procedure. I am getting some string from a table.I need to remove all empty spaces from the right side. How can I do this? Regards Igor