Does the filterExpression of the Table.Select method understand the 'IN' Clause? Who knows? Where'

  • Thread starter Thread starter Fergal O' Ceallaigh
  • Start date Start date
F

Fergal O' Ceallaigh

Hi. I searched and searched for this info (I even have the ADO Core
reference on my desk) but cannot find this information. All I want is a
comprehensive list on what the filterExpression param of the
DataTable.Select method can handle.

So far I have

ColumnName = 'string'
DateColumn < = > '12-12-03 00:00:00'
Like 'FilterExpression Doc Suc%'

as well as the sort options


In particular I am interested to know if I can use the IN clause as one does
in SQL where

select ID from Table where County IN ('Wicklow','Dublin','Derry')

Thanks so much and have a great Christmas.

-fergal
 
Hi Fergal,

Inline...

Fergal O' Ceallaigh said:
Hi. I searched and searched for this info (I even have the ADO Core
reference on my desk) but cannot find this information. All I want is a
comprehensive list on what the filterExpression param of the
DataTable.Select method can handle.

So far I have

ColumnName = 'string'
DateColumn < = > '12-12-03 00:00:00'
Click to expand...

DataColumn said:
Like 'FilterExpression Doc Suc%'
Click to expand...

alternative is Like 'FilterExpression Doc Suc*'
as well as the sort options
Click to expand...
In particular I am interested to know if I can use the IN clause as one does
in SQL where

select ID from Table where County IN ('Wicklow','Dublin','Derry')
Click to expand...

Yes, you can.

Thanks so much and have a great Christmas.
Click to expand...

Yo too :)

You might look at
DataColumn.Expression Property
..net help topic where the expression operators are described.
 
Back
Top