Re: Any idea of how to trim and pad a column

Posted in 1998

Martin Berns — Fri, 18 Sep 1998 11:51:41 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, if your x of Informix5.x is not 0, you may do this by writing an ugly stored procedure. It must be ugly as SPL is not well designed for this character-stuff. Some kind of while a[1,1] = ' ' let a = a[2,100] end while; hth martin Saleem Mohammad schrieb: > > Hi Everyone > I am new to Informix> I did work in Oracle before. I know we have > some functions for trimming and padding a column. (We have lpad, rpad, > ltrim and trim funcctions to pad and trimming in Oracle). I referred to > Informix7.2, it has function called TRIM. But I am working in > Informix5.x. So please let me know what can be done. > > Thank You in advance. > Saleem