Datatable.Select() cannot filter a value contains "#"

362 Views Asked by At

A Database has a data like these

OVS0001#R1

OVS0001#R2

OVS0001#R3

I try to filter by using Select() function .

       Datatable.Select(" ITEM_CODE='OVS0001#R1' ")

The error message shows like these

      The expression contains invalid date constant '#R1"'.
0

There are 0 best solutions below