How serializable works when multiple conditions exists in where clause?

Hi

I have one statement like

select * from UserInfo where

UserId between 1001 and 1009 and

UserName = 'XXXX'

This transaction is living under the hood of "Serializable".

In another transaction i can able to insert the values whose UserName is XXXX . How it is inserted?

Whether the first condition is alone used for the Range lock or something i misunderstood?

May i kindly know what i have to do to solve this.

Thanks in advance.

---

NANDAKUMAR.T