Re: HELP!:Informix 5 / Informix NET/ Powerbuilder 4.x " Informix adds spaces to all character type fields, is there a switch? "

I'm not sure if Informix version 5 has this feature but on 6.x and 7.x you could use the undocumented function trim() select trim(name) from 'table' This works great for us. -- Joseph Cullipher |E-mail: joseph@cannonexpress.com PO Box 364 |opinions express are those of my own and Springdale, AR 72764 USA |don't necessarily reflect those of my company On Fri, 6 Dec 1996, Hans Nieuwenburg wrote: } We are wirking with Informix 5, Informix NET and Powerbuilder 4.x. } } } Every time when we are sending a string like "John" to the field <Name> } (witch is 10 char's long) and we retreve the data like "John " } to reduce extra work on the client software we would like to retrieve the } data with no filling spaces, is there an option in Informix you can use to } set these spaces off? } } Please send reply to } ____________________________________________________________ } } e-mail from : Hans.Nieuwenburg@cmg.nl } DataBases | Programming | Optimizing | DocumentManagement | WorkFlow } ____________________________________________________________ } } CMG Finance | Laan van Kronenburg 14 } 1183 AS Amstelveen, The netherlands } Tel : (031) 020-5033000 } ____________________________________________________________ }