D
dsimcox
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]%'"
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]%'"