NOT LIKE taking forever to run

[Prav]

Hi i'm using Not Like "*TX[0-9]*" in a query and its forever to run. However
if i do Not Like "*TX[0-9]*" its works fine. Any other way to query NOT LIKE.

 

[Prav]

Sorry i mad a mistake i'm using Not Like "*TX[0-9]*" in a query and its
forever to run. However

if i do Like "*TX[0-9]*" its works fine. Any other way to query NOT LIKE.

Hi i'm using Not Like "*TX[0-9]*" in a query and its forever to run. However
if i do Not Like "*TX[0-9]*" its works fine. Any other way to query NOT LIKE.

 

[Ken Snell \(MVP\)]

Not Like is notoriously slow in ACCESS.

Assuming that you have a primary key field in the table, this type of query
might run somewhat faster:

Create a query (name it qryLike) and save it:

SELECT PrimaryKeyField
FROM TableName
WHERE FieldName Like "*TX[0-9]*";


Then create this query to show the results you want:

SELECT *
FROM TableName LEFT JOIN
qryLike ON TableName.PrimaryKeyField =
qryLike.PrimaryKeyField
WHERE qryLike.PrimaryKeyField IS NULL;

--

Ken Snell
<MS ACCESS MVP>

Sorry i mad a mistake i'm using Not Like "*TX[0-9]*" in a query and its
forever to run. However

if i do Like "*TX[0-9]*" its works fine. Any other way to query NOT LIKE.

Hi i'm using Not Like "*TX[0-9]*" in a query and its forever to run.
However
if i do Not Like "*TX[0-9]*" its works fine. Any other way to query NOT
LIKE.