"And" is not working in datable.select

This solution worked. Thank you so much!
Appreciate your quick response @jack.chan

Can you pls clarify the below syntax as well?

Not working dtMasterTable.Select("[Column5]=’ “+var1+” ’ AND [Column9]=’ “+var2+” ’ ")
vs
Working dtMasterTable.Select(“[Column5] = '”+var1+“’ AND [Column9] = '”+var2+“'”)

Wondering, if the spacing matters for the quotes.

1 Like