Extract values from string in SQL Server

satabeac...

I want to extract all the values from the below string in sql

String = \301+1\123+1\152+1\

expected output

301

123

152

dharmend...

0 3

Use the SplitString function from below article.

SQL

SELECT * FROM (
    SELECT REPLACE(REPLACE(Item,'1\',''),'\','') Item 
    FROM dbo.SplitString('\301+1\123+1\152+1\', '+1\')
) t
WHERE t.Item <> ''

Output

Item

301

123

152

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Split function in SQL Server Example: Function to Split Comma separated (Delimited) string in SQL Server 2005, 2008 and 2012