CREATE TABLE #DataToParse (StringData varchar(100),
                           TestCase varchar(100))

INSERT INTO #DataToParse (StringData,TestCase)
select 'lkasdjf s$xxxxxxxxx$lasdjf;kjaklj a;sdkjf','hidden in the middle' union all 
select '$asdkfjaskj xxx$' ,'no other data' union all
select 'aklsdfj ;kjasdf asklfj' ,'not there' union all
select '    $aksdjf as;dfkljy$' ,'at the end'  union all
select 'lskdjf s$$laksdjf asdf' ,'no data between' union all
select 'asdfjsdf$kalsdjf askfj' ,'only one in the middle' union all
select '$ksdjf sk;dfj askdfj  ' ,'only one at the beginning' union all
select 'ksdjf sk;dfj askdfj  $' ,'only one at the end' union all
select '$$', 'just $$' union all
select '$', 'just $' union all
select 'klasdjfa$kasdjf$asldkjf asd$','three $s'


select StringData,
       TestCase,
       Substring
        (StringData,
         charindex('$',StringData)+1,
         charindex('$',StringData,
                   charindex('$',StringData,
                             charindex('$',StringData)+1)) -
                             charindex('$',StringData)-1) as Result
from #DataToParse
where StringData like '%$%$%'

quote:

---

Originally posted by AlgaeSea

Hi Peso,

Just noticed that I got a reply. Anyway i tried your answer and got this error:

Line 20: Incorrect syntax near 'apply'.

Then I noticed that I was running it in a query window that was pointing to a non upgraded database.

So I switched to database running in 2005 and got this error:

Invalid object name 'dbo.fnParseList'.

I tried to find fnParseList in BOL and got no results found.

Then I searched here and found this thread. I assume you are referring the to function fnParseList found there.

I don't have time to fool with it now, but you have given me some new stuff to study. I found information about "using apply" in the BOL looks interesting.

Anyway, thanks for your help.

Laurie

---