Home Forums SQL Server 2008 T-SQL (SS2K8) Parse field with Numeric ranges and comma deliminated values RE: Parse field with Numeric ranges and comma deliminated values

  • Thank you, I was just preparing to post the create statements and a text file of some data.

    I will take a look at your code. With regards to all rows containing the same exact format; not really...

    SOME will have no range in it (44100-44110) and only contain things like 44110,44125,44157, etc (maybe three or so values, maybe 20)...

    Other fields might have multiple ranges

    ex: 441100-44110, 44128, 44524-44555, 44112, 52144

    Things like this... Makes it interesting for sure.

    <hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh