DataTable.Select Method Query Capabilities

[Joe Smith]

Hello,

Can we do SQL style SELECT queries in the DataTable.Selec t 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 !

[eye5600]

RE: DataTable.Selec t Method Query Capabilities

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