How to find a specific string value in a column. 1

[EM1107]

Guys I require to extract information from a long column but the value is not always the same.

How can I run a script that would return the information every time.

What I am trying to do is as follow:
CMP=WIN-ASO4LB0DDV6;MULTIIDX=0.500;VER
the string above is always in the column.
The value I want to get is the following: The beginning of MULTIIDX=0,500 and before the;VER value
so that all that is returned is MULTIIDX=0,500

I have some part of it working but I cannot figure out a way to eliminate the beginning of the string.

Any help would be appreciated.

 

[gmmastros]

You can use CharIndex to find the positions of the strings, and use that with SubString to get the part you want.

Ex:

Declare @Temp Table(Data VarChar(200));

Insert Into @Temp Values('CMP=WIN-ASO4LB0DDV6;MULTIIDX=0.500;VER');

Select Data,
       CharIndex(';MULTIIDX', Data),
       CharIndex(';VER', Data),
       SubString(Data, CharIndex(';MULTIIDX', Data)+1, CharIndex(';VER', Data)-CharIndex(';MULTIIDX', Data))
From   @Temp

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom