Q:

How to split a string in SQL and display that value

I have a column (Col A) with a value that goes like this: 
ThisValue=The Value;DateFrom=01/01/01;Regulated=No;

I want to select only The Value (From Col A) and have it displayed in a subquery.
So far I've tried to use REPLACE, but have had a hard time getting it to work inside a select statement.

A:

Use SUBSTRING and CHARINDEX.
QUERY
declare @str as varchar(50)

set @str = 'ThisValue=The Value;DateFrom=01/01/01;Regulated=No;'

select substring(@str,charindex('=',@str,1)+1,
       ((charindex(';',@str,1))-(charindex('=',@str,1))-1));

SQL Fiddle

