How do i know weather specific record is locked or not using sp_lock or another way?

for Ex.
I have an Employees Table. When another user is editing Employee '001' record. Another user try to edit same record, need to check the lock status before start editing.

I use adLockPessiMistic to open employee table.

Thank u in advance,

dinesh