Split String

• martin.kerr 34088

  SSCommitted

  Points: 1752

  More actions

  December 9, 2011 at 5:15 am

  #247495

  Hi All,

  I am looking to split then update a string i.e. '123 example street, example town, example city'

  I am looking to split it into its address lines, therefore splitting it at each , ,

  Is there a way of doing this?

  Thanks in advance

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  December 9, 2011 at 5:19 am

  #1419232

  Check out this article[/url], it explains how to do exactly what you need.

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---