*if a record is locked it´s NOT in the result select MYFIELD from MYTABLE WITH (readpast) where MYFIELD1 = "00" *if an update has been committed, new val, else old val select MYFIELD from MYTABLE WITH (readcommitted) where MYFIELD1 = "00"Hope this helps