Hi,

I'm having trouble getting this to work

In SQL Server , you can query for "SearchText___" and the underscore stands for 1 character.

How can one do the same in the Datatable.Select function? What is the wildcard for 1 character? I always thought the underscore was standard SQL?

Code:
DataRow[] drDataRow= l_DataTable.Select( "[master] like 'Menu___'", "somecolumn" );
returns nothing in C#, is does in SQL server