>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.
invert the logic:
declare @MyList varchar(200)
SET @MyList = '''anc'',''add'',''xxx'''+','
if exists(select 1 where @MyList LIKE '%''anc'',%')
SELECT 'exists'