Post reply

Columns of equal width in answer..?

  • January 29, 2008 at 4:33 am

    #63007

    Hi!

    Probably a really simple answer to this one, but I can't seem to figure it out...

    If I for examle want to query 'select quantity from orders' and I want every line to be of equal width ('3' should be written '0003'), how do I do?

    Thanks in advance!

    /Martin

  • January 29, 2008 at 5:44 am

    #772797

    REPLACE(STR(quantity, 4), ' ', '0')

    _____________
    Code for TallyGenerator

  • January 29, 2008 at 6:50 am

    #772831

    Thanks a lot! 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply