Re: Bug in concatenation Operator ?

Posted in 1998

David Williams — Thu, 26 Feb 1998 07:26:21 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <34F3F8D3.F72BF87A@stueken.de>, Dirk Niemeier <dirk.niemeier@stueken.de> writes >hello, > >is it possible, that there is a bug in concatenation operator '||' ? >I'm using SE 7.22 > >My try in SPL: > >.. >DEFINE test CHAR(10); >... >LET test = 'A'; >RETURN test || 'B'; RETURN TRIM(test) || 'B' Only works in Online 7.1 and above. May work on SE I'm not sure.. >... > >the result is not 'AB' but 'A B' !!!??? >Is it really that what we want ? >If I use LENGTH(test) the result is 1. >The try : RETURN 'B' || test --- gets BA. > >regards > Dirk Niemeier > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care