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

Posted in 1998

Vijay R. Anisetti — Thu, 09 Jul 1998 16:44:10 -0400 — source: Informix-list mailing list archive (1991-1998)

Kathy Hildebrand wrote: > > 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 shouldn't the following do the job? SELECT cost_ctr_code[1,1] ||","||cost_ctr_name from costctr; > > Kathy Hildebrand > kathy@htscm.com <mailto:kathy@htscm.com> > :-) > Designer/Programmer Vj