Hi. I’m using the following code to select rows to keep:
db_in.Select(“[Name] NOT IN (‘A’, ‘B’)”).CopyToDataTable
I’d like to replace ‘A’ and ‘B’ with a variable var1. I’ve tried
db_in.Select(“[Name] NOT IN (var1)”).CopyToDataTable
But that returns an error; "Cannot find column “var1"”.
Any suggestions?