*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"