Hello everyone here. I am trying to get data from my database here WHERE Name is not in a List<string> and I cannot figure out how I can do this at all. Is this possible? Thanks in advance for the help, I do very much appreciate it.
Derived from SQL Server Books Online IN (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms177682.aspx, example A has:
WHERE e.JobTitle IN ('Design Engineer', 'Tool Designer', 'Marketing Assistant');
You should format your string, something like:
WHERE [Food] NOT IN ('Apple, 'Berry', 'Cherry');
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?