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


Any advise on how to resove this problem

Thanks for the help
Cao