Click to See Complete Forum and Search --> : DataTable.Select and wildcards


bewa
March 14th, 2005, 03:38 AM
Hi,

I'm having trouble getting this to work :blush:

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?

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