Re: LENGTH function and trailing spaces

kbradley@130.35.1.6 (Kirk Bradley - Mainframe and Integration Technologies) wrote: > > 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) > This is beginning to sound like a troll to me. Exactly what are you trying to accomplish that you need help with? If your intent is to start a flame-war then you probably don't need help from me at all and I'll just drop out. If you're intent is to discuss whether LENGTH() is something that should be an ANSI standard then just go ahead and say so. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ One who prefers INTEGER lengths himself. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________