> Well, job_number is string so it was
>
> select distinct job_number from sawmembers
> where job_number <> ''
>
> and it didn't make it run any faster.

Why a string?

I would have expected job_number to be a number - if you
want it displayed differently I use a calculated field from
the number. That way I get numerical order of job number
what ever the string layout.

I don't know if removing variable length data from the
distinct will help, but since I populate job_number from a
generator I don't need the distinct.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services