?
Or if someone has a better solution I would love to here it.
Roger
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 3:18 AM
To: Roger Davis; [EMAIL PROTECTED]
Subject: Re: Help with Proper SQL to Limit number of rows
Hi Roger,
> Q
Hi Roger,
> Quick rundown.
>
> Table:
>
> Assignments
> CaseID auto_increment
> FileNumber char(18)
> FirstName char(20)
> LastName char(20)
> and on and on and on
> Indexes on
> CaseID (Primary)
> FileNumber
> Name (LastName, FirstName)
>
> What I would like to do is something along the lines of
