Filter datatable row with condition using c#

//////////////////////////

//////////////for like conditon

            DataTable checkCluster = Tally_COSTCENTREALLOCATIONS_LIST.Select("Name LIKE 'AP-KMR%'").CopyToDataTable(); //dv4.ToTable();

//////////////for Data  greater than and less than condition

 DataTable checkdate = Tally_VOUCHER.Select("DATE >= '20170401' and DATE <= '20180331'").CopyToDataTable();


//////////////for the date between condition

 DataTable checkdate = Tally_VOUCHER.Select("DATE between '20170401' and  '20180331'").CopyToDataTable();