SET @LXListFirstName='S\_SH%'

SELECT Member.Numero
 FROM Member
 WHERE UPPER(Member.FirstName) LIKE @LXListFirstName ESCAPE '\'
 ORDER BY Member.LastName,Member.FirstName 

>I just discoverd something I was not aware. The _ character is used as a filtering character, such as a wild card, when doing a query. The following:
>
>

>DECLARE @LXListFirstName Varchar(16)
>
>SET @LXListFirstName='S_SH%'
>
>SELECT Member.Numero
> FROM Member
> WHERE UPPER(Member.FirstName) LIKE @LXListFirstName
> ORDER BY Member.LastName,Member.FirstName 
>

>
>...will find all records having S as the first character and SH for the 3rd and 4th character no matter what is the second letter. So, it found results such as:
>
>Sushil
>Sasha
>Sushma
>Sushell
>Sushi
>
>How can I turn that OFF? Basically, I really needed to find S_Sh as is and not all those records.