>Do you have an index on the table being SCANned? If you have an index
>on the HOLD column you will get results you might not expect...


No there is no index on the hold field. Thank You for the reply