coverston

you want the select to honor locks - but you want to read the locked data?? - that seems like a bit of contradiction to me .. In case i've got you wrong - would READPAST help - this would just skip the locked rows???