Datatable select not equal issues



Hi I have a datatable select issue. My syntax is like this:

logdt"[Robot Start Date] = ‘"+thisbatchtime.tostring+"’ and [Completion Date] not like ‘Exception’").copytodatatable

I keep getting source contains no datarow, but there should be.
And this only happens after i added the part after “and…”



Please find this post as reference.


Hi, the part which is equal works fine for me. But I dont know how to get the “not like” part to work.


I checked with following example.
DT.Select("([name]='ak' or [name]='aksh') and [name] not like '%sh%'").CopyToDataTable