Tim-

PMFJI, but it wouldn't appear your Select statement is optimized since you don't have any index expressions that match your WERE clauses (unless there are more than the one you quote here). I'd suggest you get the query optimized from with VFP and then extrapolate to your VB.NET project.

>Here is my SQL select statement and reader code:
>
>_____________________________________________________________________________
> Dim sb As New StringBuilder
>sb.Append("SELECT job_num, product, slot FROM prodwip WHERE job_num = " + " '" + txtJobNum.Text + "'")
> sb.Append(" AND (product = '877'")
> sb.Append(" OR product = '863'")
> sb.Append(" OR product = 'NP2')")
>
< snip>

>This is the Index Expression from Foxpro:
>
>TRIM(DTOS(canceled))+job_num