Re: LENGTH function and trailing spaces

Now we're getting somewhere. Can you give me an example then of why you'd ever use LENGTH in SQL? Especially since the function will not allow an expression? I can't think of anything particularly useful that LENGTH can do for me. p.s. One reason to havethe REAL length of columns (not the stripped length) is to be able to calculate how much space a row takes on disk (you have to add in the column, row and block overheads of course) Kerry Sainsbury (kerry@kcbbs.gen.nz) wrote: : In article <3m9he0$3dk@dcsun4.us.oracle.com>, : kbradley@130.35.1.6 (Kirk Bradley - Mainframe and Integration Technologies) wrote: : > : > Is that clearer? Is it something anybody ever needs/wants to do? : I can't imagine why you'd want to do this. : --------------------------------------,------------------------------------- : Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ : Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* : | mathcs.emory.edu:/pub/informix/faq/* : +64 9 377-4473 (work) 279-3571 (home) | http://www.garpac.com/informix.html -- Kirk Bradley Oracle Corporation Mainframe and Integration Technologies Group