SELECT
SUBSTRING(col1, 14, 26) AS Col1,
SUBSTRING(col2, 17, 26) AS Col2
FROM col
This query will bring the desired result.
Query Result:
Col1 Col2
IWantToReturnThisIn1Column IWantToReturnThisInColumn2
Above can also be achieved by using CHARINDEX in case straing between "=" and ";" is required for different rows.
SELECT
SUBSTRING(Col1, (CHARINDEX('=', col1, 1) + 1), (CHARINDEX(';', col1) - (CHARINDEX('=', col1, 1) + 1))),
SUBSTRING(Col2, (CHARINDEX('=', col2, 1) + 1), (LEN(col2) - (CHARINDEX('=', col2, 1))))
FROM col
I hope this will fulfill the requirement.