Home Forums SQL Server 2008 SQL Server Newbies Split Numbers RE: Split Numbers

  • May 12, 2015 at 11:13 am

    #1797346

    A pattern splitter can help you with this and I hope that you can complete the solution.

    Reference: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

    Select *

    from #tbl_data

    CROSS APPLY (SELECT TOP 1 Item

    FROM dbo.PatternSplitCM( PONumber, '%[0-9]%') s

    WHERE Matched = 1

    ORDER BY ItemNumber DESC) PO

    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