Re: Space-padded Strings and Stored Procedures

Posted in 2000

Paul Harman — Fri, 11 Feb 2000 15:33:12 -0000 — source: Informix-list mailing list archive (1991-1998)

David Kleppinger <David_Kleppinger@dts.edu> wrote in message news:38A4233E.5B2FC577@dts.edu... > I don't think clipped after a constant is valid. > How about trying: > LET details="Added " || valuename clipped || " value"; Someone suggested (via email) doing: SELECT TRIM(stringname) FROM tablename; ...which seems to work. Many thanks y'all! Paul