<p>Vous trouverez peut-être la solution dans <em><a href="http://www.codeproject.com/KB/database/SQL_UDF_to_Parse_a_String.aspx">SQL User Defined Function to Parse a Delimited String</a></em> utile (provenant de <a href="http://en.wikipedia.org/wiki/The_Code_Project">The Code Project</a>).</p>
<p>Vous pouvez utiliser cette logique simple :</p>
<pre><code class="lang-auto">Declare @products varchar(200) = '1|20|3|343|44|6|8765'
Declare @individual varchar(20) = null
WHILE LEN(@products) > 0
BEGIN
IF PATINDEX('%|%', @products) > 0
BEGIN
SET @individual = SUBSTRING(@products,
0,
PATINDEX('%|%', @products))
SELECT @individual
SET @products = SUBSTRING(@products,
LEN(@individual + '|') + 1,
LEN(@products))
END
ELSE
BEGIN
SET @individual = @products
SET @products = NULL
SELECT @individual
END
END
</code></pre>
