<div>
You can use the CHARINDEX() function repeatedly. &nbsp;But I am not sure that alone is going to help much in your quest to split unformatted City State ZIP values.
</div>


You can use the CHARINDEX() function repeatedly.  But I am not sure that alone is going to help much in your quest to split unformatted City State ZIP values.

<div>
But I see you have already been given this same answer here:<br />
<a href="https://www.experts-exchange.com/questions/26013136/T-sql-contain.html" rel="ugc">https://www.experts-exchange.com/questions/26013136/T-sql-contain.html</a>
</div>


But I see you have already been given this same answer here:
https://www.experts-exchange.com/questions/26013136/T-sql-contain.html [https://www.experts-exchange.com/questions/26013136/T-sql-contain.html]

<div>
How would you do it repeatedly? Charindex(' ',mystring) This would just return the psition of the first ' '. How would you find out the second ' '?
</div>


How would you do it repeatedly? Charindex(' ',mystring) This would just return the psition of the first ' '. How would you find out the second ' '?

<div>
I posted my solution to your unformatted City State ZIP in your other thread (and yes I realize you cannot read code when using EE Mobile):<br />
<a href="https://www.experts-exchange.com/questions/25986403/Address-split.html" rel="ugc">https://www.experts-exchange.com/questions/25986403/Address-split.html</a><br />
<br />
See there for a good example how to do it.
</div>


I posted my solution to your unformatted City State ZIP in your other thread (and yes I realize you cannot read code when using EE Mobile):
https://www.experts-exchange.com/questions/25986403/Address-split.html [https://www.experts-exchange.com/questions/25986403/Address-split.html]

See there for a good example how to do it.

Returns a table from a deliminated list split function

fn-split.sql

<div>
<div class="content wysiwyg-content">
How can I find specific &nbsp;position of each space? Sample: This is a test only.<br />

</div>
</div>


How can I find specific  position of each space? Sample: This is a test only.


Find space in string

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.