>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.