How to extract strings between two special charactors

[RJL1]

I have a sting that contains a qty (in this case 50) that I need to extract. I am having trouble trying to get just he 50 out of the string below

Quantity Received=50;Detail Row=1;

Any suggestion on how to get this value from the string. My field type is text in the DB

Thanks
RJL

 

[briangriffin]

Does each record begin with ''Quantity Received=' ?


declare @v_test varchar(50);
set @v_test = 'Quantity Received=50;Detail Row=1;'

select SUBSTRING(@v_test,19,charindex(';',@v_test) - 19)