Re: Puzzled by SQL...........can you help

Posted in 1998

ccremid — Thu, 09 Jul 1998 15:05:22 -0400 — source: Informix-list mailing list archive (1991-1998)

Kathy Hildebrand wrote: > {snip..] > > select cost_ctr_code [1,LENGTH(cost_ctr_code)] || ", " || cost_ctr_name > from costctr > Try using TRIM().... select TRIM(cost_ctr_code)|| ", " || cost_ctr_name from costctr Hope This helps Tino