Re: remove empty spaces in char type in SPL?

[This followup was posted to comp.databases.informix and a copy was sent to the cited author.] In article <34772ECC.4DA5E89B@netcentre.com.sg>, dominic@netcentre.com.sg says... > I am trying to pass a string variable into the SPL > type char(100). However, if the string is less than > 100 characters, I will have spaces after that. > How can I remove the trailing spaces? Any help > will be appreciated. > You may want to try the TRIM Function TRIM LEADING trim character source character TRAILING value expression FROM value expression BOTH trim character source character value expression FROM value expression I hope that this helps -- Michael J. Erickson (Michael_Erickson@iname.com) Any opinions expressed here are my own and do not necessarily reflect those of my employer or clients.