Re: Help: concatenating/trimming strings in SQL

Re: >} SELECT block_no || " " || street_name >} FROM tb1 produces: >} 2 Orchard Road instead of: >} 2 Orchard Road I didn't see the original post, but... I think that if you define block_no as a VARCHAR, the SELECT would produce the output you want. I don't know if you consider that an option, though. June ---- June Tong Informix Software ---- ---- junet@informix.com (415)926-6140 ----