Re: Stored Procedures & removing Blanks

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/