Re: Stored Procedures & removing Blanks

Hi to all This TRIM() function in wich version of informix engines works, it's possible to work on INFORMIX ver 5.0 Peter Lancashire wrote: > CADRMS wrote: > > > > Hello, > > > > I am writing a stored procedure which concatenates some address strings > > into one string. > > There are a bunch of spaces between the final string. "CLIPPED" will not > > work in a stored procedure. > > nore will "length" in the context w_length=LENGTH(string) and > > string[1,w_length]. > > What can I do to remove these spaces. > > > > Thanks, > Use TRIM(mystring) and its variants thus: > > LET string = TRIM(TRAILING FROM string1) || ' ' || string2; > -- > Peter Lancashire > Information Systems Specialist, Bayer plc > Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK > Tel: +44-1635-562258, Fax: +44-1635-562281 > --- > If all else fails, read the instructions. > All opinions are my own and not those of Bayer plc. > My Internet plumbing does not allow me to mail and post news together. > Sorry. > --- > Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/