How to retain trailing spaces in VARCHAR

Raj wrote >Informix Gurus, > Is there a way to retain trailing spaces in a VARCHAR field? The >trailing spaces are explicitly inserted, but on a select, the spaces are >gone. Leading spaces however, are retained. > Any and all responses on this matter appreicated. None that I know of, I use varchars in SPL to do exactly what you are trying to avoid, thus enabling char variables to be concatenated without the trailing spaces! Do the trailing spaces matter that much? I would be interested in an answer to this one too. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk