Select and update SQL

I need to select a value from a field and then add 1 to it and return that value. I know I have to do 2 queries to accomplish this but I need to do it so someone cant do the same thing at the same time. Is there a way to lockout that field until I update it in SQL?

This should do it...

http://www.aspalliance.com/Michiel/recordlocks.asp