I understand that using the NOLOCK in a select statement will help with table locking in SQLServer 7, but when I try to use it the server reports that it isn't in the right spot -- I checked the BOL and I believe I'm using it correctly.

Can nolock be applied to updates and inserts too? And what's the best way to use it?

My usage:
SELECT * FROM myTable(NOLOCK) ...

Thanks from a newbie,

John