Thanks Borislav and Fabio,

Both of your examples are useful too.

Gary


>>Hi,
>>
>>I'm trying to find if a string exists as part of another string like the $ operator in Fox. I'm using this in a CASE statement.
>>
>>I need to use a variable for the right hand side of the comparison and can't get it to work for the life of me!
>>
>>Works fine:
>>if exists(select 1 where 'anc' in ('anc','add','xxx'))
>>
>>Fails miserably:
>>declare @MyList varchar(20)
>>-- Code to build list...
>>print @MyList
>>displays 'anc','add','xxx'
>>
>>if exists(select 1 where 'anc' in (@MyList)) -- Fails
>>
>>Perhaps I'm not building my list string properly?
>>
>>Thanks.
>
>
>PATHINDEX() and CHARINDEX(), but I prefer Naomi's example with Temp Table.