using distinct in datatable

[Patrick.O.Ige]

I'm trying to do distinct below in a datatable
but i get the error :-
Syntax error: Missing operand after 'Code' operator.
Any ideas?

string strExpr = "DISTINCT Code LIKE '%ve%'" ;
DataRow[] XmlRow = myTable.Select(strExpr);

 

[Anthony Merante]

I not sure you can use DISTINCT in like that. The string param in Select()
is strickly a Where clause. I think you're going to have to remove the
DISTINCT.

Tony