What does this have to do with his problem???

lester@... wrote:

>>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.
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]