I need the syntax for a where clause on the following table:
rec_id desc stores
1 abc '1','3'
2 def '1','2','3'
3 ghi '2','4'
declare @var varchar(3)
set @var = '''2'''
select desc from table
where @var found in the stores column ?????
Thanks for any help,
Marc Miller