Puzzled by SQL...........can you help

Posted in 1998

Kathy Hildebrand — Thu, 9 Jul 1998 10:20:49 -0700 — source: Informix-list mailing list archive (1991-1998)

Can anyone get me an alternative to this SQL statement (it won't work). It doesn't like the LENGTH function in the brackets but I need to cut off the length of my first concatenated field. Any Ideas? select cost_ctr_code [1,LENGTH(cost_ctr_code)] || ", " || cost_ctr_name from costctr Kathy Hildebrand kathy@htscm.com <mailto:kathy@htscm.com> :-) Designer/Programmer