I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won't update the record. I want to check the record lock before performing the update statement. I don't want to check the SQL code after performing the update statement. What I want is: I want to check the record lock while selecting the record in read only mode itself (in SQL). Please help me to check the record lock.