• I do agree all your points. I just thought this one while reading/replying to my another post. As all of you mentioned, it will break the original name into some useless one. I wanted to know the different opinion on this topic from the sql masters. Thats all the intention 🙂

    Jeff,

    Coming back to your question, count 1 to 100,

    select sum(n) from tally where n < 101

    am i right 🙂

    karthik