> Hi All
> It seems that I have an index problem
>
> Select * from Ostrip where DepotId='23' and InvNo='5016308'
> returns null
>
> however
>
> Select * from Ostrip where DepotId='23' and PrnId='20' and
> InvNo='5016308'
> returns the record
>
> and
>
> Select * from Ostrip where InvNo='5016308' returns the record
>
> All queries should have returned at least the the same record
>

You're doing these from the same transaction? It looks like you've got
different data visible to different transactions.

N.