I need to send a value to a sql statement that will hold a list of fields to include or exclude from my results.
DECLARE @ListOfFields NVARCHAR(500),
SET @ListOfFields = '(''Test1'', ''Test2'', ''Test3'')'
SET @MyField = 'Test1'
IF @MyField NOT IN (@ListOfFields)
print 'does not exist'
My Test1 should be in my list of fields. Yet it doesn't match. I have tried to reformat the string a dozen different ways, and I cannot get 'exists'. Any Ideas what I am missing here on how to format the string list of field names?