Re: ***Trimming field data*** Reposted

Dean hobbs (deanh@Unipalm.Pipex.Com) wrote: : Thanks to all who attempted to solve my poblem. I will try and explain : better what I am trying to do. : I have an Informix database with a character field called ACC_NAME that : can be upto 10 characters. I have attached the table to an access : database and when I view the field in data view the ACC_NAME field is : right filled with spaces. If I try and link this field to an ACC_NAME : field in an access table that does not have spaces right filled, there is : obviously no matches. I am fairly new to Informix but in other databases : I have used you can usually trim off the spaces so that there are none on : the end of the field. Can you redefine the column as a VARCHAR(0,10)? You may have to unload/clear out spaces/reload the table, but VARCHAR null-terminates the column rather than pads with spaces as CHARs do. You need to be using ONLINE rather than Standard Engine to do this. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Principal Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer. : I have tried using SELECT TRIM(Acc_Name) as suggested by Craig but it says : TRIM function not found. : I hope this clarifies my question. : Dean Hobbs : deanh@unipalm.pipex.com -- ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Principal Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer.