Need Help - finding values in variables in T-SQL 1

[Kieran777]

I have a Variable with a list of items (see @a) below. I need to be able to check the variable to see if an item is in the list and the perform relevant action. How can you do this in T-SQL. eg something like below code - but that doesn't work.


declare @a varchar(80)
set @a = 'xxx' + ',' + 'yyy'
if 'xxx' in (@a)
print 'Its There!'
else
print 'Its NOT There!'
print 'A=' + @a

Print 'Also Tried this with no luck'
set @a = char(39) + 'xxx' + char(39) + ',' + char(39) + 'yyy' + Char(39)
if 'xxx' in (@a)
print 'Its There!'
else
print 'Its NOT There!'
print 'A=' + @a

print 'How do I get it to find ' + char(39) + 'xxx' + char(39) + ' in ' + @a + '?'

Any help appreciated.
cheers
B-(

 

[tlbroadbent]

If Charindex('xxx', @a) > 0
Print 'I found it!'
Else
Print 'Not here!'

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm