Simple filter question?

[bbuk]

Hi

I've been trying to filter an ADO recordset (rsType) to distinguish between a list containing data like:

2 Axle Class V

and

2 Axle Class VII

etc.

with

rsType.Filter = "field2 Like '*CLASS V*'"

it returns both Class V and Class VII. Is there a way that I am missing?

TIA

Andy

 

[CasperTFG]

Hey Andy you are using a wildcard operator afterwards... It also depends on which RDBM you are using.

[SQL Server]
rsType.Filter = "field2 Like '%CLASS V'"

[MS Access]
rsType.Filter = "field2 Like '*CLASS V'"



Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[bbuk]

Thanks Casper

I'm using MS Access, and it dosn't allow a wildcard * only at the start of the string -

rsType.Filter = "field2 Like '*CLASS V'"

causes error

"3001 - Arguments are of wrong type, out of acceptable range or in conflict with one another"


Any other ideas?