title: How to split string field value by two delimiters in SQL Server
body: <p>I have the client table with string value field called <code>Address</code> separated by commas and spaces. I want a query to split the address by the space and the comma into separate columns. I could split the string by one delimiter but unfortunately couldn't find a way to split by two.</p>
  <p>Please help.</p>
  <p>Here is the existing table and the resulting table that should be generated:</p>
  <p><a href="https://i.stack.imgur.com/J6zQx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J6zQx.png" alt="Here is the existing table and the resulting table that should be generated" /></a></p>