it is the spacing ,
let say
var1=‘abc’
var2=‘def’
dtMasterTable.Select("[Column5]=’ “+var1+” ’ AND [Column9]=’ “+var2+” ’ ")
will translate to
dtMasterTable.Select("[Column5]=' abc ' AND [Column9]=' def '")
which is wrong
1 Like