I'm trying to determine if any matching records exist on a LIKE query
performing a partial match of last names to a remote back-end database in
the most efficient manner possible. LAN Traffic appears to be the
bottleneck. This column is already indexed, and all I'm trying to determine
is whether no records, or at least one record, exists. My solution is the
following:
SELECT COUNT(*) FROM
(SELECT TOP 1 FROM table WHERE LastName LIKE "*match*")
My belief is that this will stop after finding the first matching record,
and return either a 0 (no matching records) or a 1 (at least one matching
record).
Any suggestions for an even better solution in MS Access 2000?
Thanks!
*David*