RE: Stored Procedures and clipping strings

In stored procedures, the clipped function is trim(). So, try LET c = trim(a) || trim(b) Hope that helps, Anisha ******************************** Standard disclaimers apply ******************************** ______________________________ Reply Separator _________________________________ Subject: RE: Stored Procedures and clipping strings Author: Non-HP-informix-list-owner (informix-list-owner@rmy.emory.edu) at HP-Boise,mimegw4 Date: 01/30/97 9:38 If you like to have this c="xy" You have to do c=x clipped,y clipped ---------- From: Galt von Holten To: informix-list@rmy.emory.edu Subject: Stored Procedures and clipping strings Date: Wednesday 29 de January de 1997 9:37AM Hello world i am trying to conncat two char-variables within a stored procedure. the operator || works fine, but: informix chars are space terminated and the conncatenation operator does not clip (skip all ending spaces) the strings. example: DEFINE a, b CHAR(10); DEFINE c CHAR(20); LET a = "x"; LET b = "y"; LET c = a || b; The variable c has now the values "x y ". I would like to have c = "xy ". HOW CAN I DO THIS ??? ////// ------------------------------ooo-O-O-ooo---------------------------- Galt von Holten U Tel.: +49 421 / 20 20 446 messerknecht meister informationssysteme Fax: +49 421 / 20 20 288 Linzer Str. 3-5, D-28359 Bremen E-Mail: gvh@mds-hb.de ---------------------------------------------------------------------