DataTable.Select Method Query Capabilities

[Guest]

Hello,

Can we do SQL style SELECT queries in the DataTable.Select Method.

e.g Filter String Expression = id < 5 AND (age <20 OR age >50)

My goal is to be able to do advanced queries on a DataTable apart from
simple column based query.

If it is not possible to do it through DataTable, what would be the best way
to integrate advanced queries.

Thanks for your help in advance !

 

[Guest]

I had trouble when selecting on a string that contained an apostrophe. Think
ahead.