>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.
Try
declare @MyList table (Descr varchar(10))
insert into @MyList values ('anc'),('add'),('xxx')
if exists (select 1 where 'anc' in (select Descr from @MyList))
If it's not broken, fix it until it is.
My Blog