Mike Grover schrieb:

>
> Ok, I see.
>
> what I am wanting to do is just get the first record that matches a query.
>
> is there a way to get just the first matching record and not even read the
>
> rest of the matching records?

You can:
- write a stored procedure:
- or give:
SELECT * FROM EXPERIAN WHERE
<Your_primary_key_field> =
( SELECT MIN ( <Your_primary_key_field> ) FROM EXPERIAN
WHERE ZIP='66846' AND ZIP4='1160' )
a try.


Luc.