>I have an ODBC connection to an Oracle 8 database. All of the queries I have run so far seem to run pretty quickly. I have one now that takes about 10-12 minutes to execute. It takes about 2 second in SQL+. The table is about 67000 records.
>

>= sqlexec(liconnect,"select * from wps_mgr.ws_scale_ticket where ;   ws_scale_ticket.permit_no like 'BC%-2' and ;
>   ws_scale_ticket.ticket_date >= 20020401 and ;
>   ws_scale_ticket.ticket_date <= 20030331","tictemp")
>

>Any suggestions would be appreciated.

I'd get date comparison in front :

sqlexec(liconnect,"select * from wps_mgr.ws_scale_ticket where ;
ws_scale_ticket.ticket_date between 20020401 and 20030331 and ;
ws_scale_ticket.permit_no like 'BC%-2',"tictemp")

Cetin