"dsimcox" wrote in message
...
I'm using VBA and ADO to retrieve a recordset from SQL Server - then
filtering the recordset to get the target records.

Some of my records have a numeric prefix - and some have an alpha prefix.

In my source query I use "partNo LIKE '[A-Z]%'" to extract the recordset.
But when I try to use the same logic in the recordset filter, it fails to
find the records. I've tested the result by filtering for the exact
prefix
("partNo LIKE 'WW6%'") and it works, so I know the records are there. But
I
need a more general way of defining the filter

Here's the filter criteria that fails. It returns NO records - when
records
like WW65-ABCD exist. Can someone point me to another solution?

rsAddAllRaw.Filter = "partNo LIKE '[A-Z]%'"

Hi dsimcox,
just maybe if you retrieve the set from the SQL server T-SQL is used in a
stored procedure (?) Then the % is a wildcard character.If you use VBA and
ADO then * is the wild card character.

Try rsAddAllRaw.Filter = "partNo LIKE '[A-Z]*'"
Just for fun :)
hth
Gys