> When we run a query such as
> Select *
> from TheTable
> where TheTable.Type in (342, 234, 6372, 234)
> and TheTable.Status = 5
> and InUse = 'T'
>

C,
I only use the in clause on (very) small tables - it's not efficient on such
large record numbers.
Alan