Home Forums SQL Server 2008 T-SQL (SS2K8) concatenate with leading zeros RE: concatenate with leading zeros

  • September 9, 2013 at 2:47 pm

    #1648660

    John.Hagen (9/9/2013)

    it turns out it is not working correctly. It is adding all the zeros to the front and not to the 2 parts.

    Column 1 - 12345 should be 6 characters 012345

    Column 2 - 1 should be 3 characters 001.

    The code you showed in returning

    000123451 not 012345001 as I am trying to get.

    I'm sure that you can figure out how to correct the code now that you have an example. That will help you to understand it better.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2