Re: need UCASE and TRIM functions

There is a trim function in Informix. It was undocumented in 6.x but is documented in the 7.x manuals. As for the upper case I believe that there is a SPL for this in the IIUG archives. -- 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 12 Dec 1996, BBertovich wrote: > multi-platform software developer client/server application needs > functions or stored procedures to convert char and varchar to upper case. > also, to trim rightmost spaces ... i'm sure many others have solved this > problem ... > sybase, sql server, oracle and others have built in functions ... informix > does not. > help ... e-mail bbertovich@aol.com (yes, 2 b's) ... thx. >