<div>
So, in your above example, are you saying you want the final result to be:<br />
&lt;a href='mypage.asp?code=AB'&gt;<wbr />AB&lt;/a&gt;&lt;a href='mypage.asp?code=BC'&gt;<wbr />BC&lt;/a&gt;&lt;a href='mypage.asp?code=CD'&gt;<wbr />CD&lt;/a&gt;<br />
<br />

</div>


So, in your above example, are you saying you want the final result to be:
<a href='mypage.asp?code=AB'>AB</a><a href='mypage.asp?code=BC'>BC</a><a href='mypage.asp?code=CD'>CD</a>



<div>
<div class="content wysiwyg-content">
hello all,<br />
I'm looking to have a user defined function or a function i can include in a new field in the table itself based on the existing field named: code<br />
<br />
i have a table with a field with the following data:<br />
code = &quot;AB, BC, CD&quot;<br />
this field has variable length. so there could be x number of codes.<br />
<br />
i would like to convert the field to: &lt;a href='mypage.asp?code=' &amp;&nbsp;code1 &amp;&nbsp;&quot;'&gt;&quot; &amp;&nbsp;code1 &amp;&nbsp;&quot;&lt;/a&gt;&quot; <br />
and then loop thru all codes. <br />
<br />
thank you all.
</div>
</div>


hello all,
I'm looking to have a user defined function or a function i can include in a new field in the table itself based on the existing field named: code

i have a table with a field with the following data:
code = "AB, BC, CD"
this field has variable length. so there could be x number of codes.

i would like to convert the field to: <a href='mypage.asp?code=' & code1 & "'>" & code1 & "</a>" 
and then loop thru all codes. 

thank you all.

function to replace comma, then loop

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.