Thanks all for your help.
>>I have this SQL syntax and I need to know why they put WITH (UPDLOCK) in this statement. Please help
>>
>>
>>select aa.field_10 from mytable aa WITH (UPDLOCK)
>>
>>
>>Thanks,
>>Sam
>
>From SQL help ..
>
>Specifies that update locks are to be taken and held until the transaction completes.