Post reply

Help with substring

  • February 24, 2012 at 11:57 am

    #1451539

    depending on your business rules, it could be as simple as a concatenation and replace function.

    select '0'+REPLACE(code,'.','.0') from

    This concatenates a '0' on the front and replaces every '.' with '.0' which i think gets you what you want.

    If you have more complicated requirements, I bet a nifty splitter and tally table would do wonders!

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • February 24, 2012 at 12:21 pm

    #1451552

    Thank you very much. Almost too easy, thanks for a second set of eyes on this.

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

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