Ucase in DataTable.Select(

Ucase in DataTable.Select(

If you want to apply a filter condition on base of upper cases like what we do in sql server as ucase(columnname)=<UPPERCASE VALUE> .

In ADO.NET - Just make it

 datatable.CaseSensitive = false;  

syntax:

 dtCopy.CaseSensitive = false;  
 DataRow[] drFilter = dtCopy.Select("Source_Dir=’/LOCAL/HOME’”);  
 dtCopy.CaseSensitive = true;