Re: Trimming field data

In article <47aem4$gh2@soap.news.pipex.net> deanh@Unipalm.Pipex.Com "Dean hobbs" writes: > Can anybody tell me if there is a way to trim data in an informix > database. I currently have data in a field that has spaces tagged onto > the end of it and I would like to remove it. Is it the way in which the data is displayed or stored which you are asking about? If it's how it's store you don't state which engine you are using. If it's SE then char data is store as fixed length as defined by the info in 'syscolumns', end of story. In OL you can have variable lenght records (in effect). -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================