>Select ;
>        Ramp, ;
>        Vendor, ;
>        VendCity, ;
>        VendSt, ;
>        HourCount ;
>    Where ;
>        Upper( Ramp ) = 'CHICAGO' And ;
>        Between( HourCount, 37, 48 ) And ;
>        Upper( Vendor ) = 'NIKE' And ;
>        Not Empty( Ramp ) And ;
>        Empty( HourCount ) ;
>    Into Cursor qVendorTimes NoFilter
>

>
>I'm afraid to break the SQL down into multiple SQL's because writing out 27,000 records is going to be slow.

There are 2 pairs of conditions there that seem wrong:

upper( ramp) = 'CHICAGO' and not empty( ramp)
I would remove the "not empty( ramp)" part

and

between ( hourcount, 37, 48) and empty( hourcount)
Make up your mind... you want specific hourcounts or empty hourcounts?

Alex