>>

>>SET @LXListFirstName='S\_SH%'
>>
>>SELECT Member.Numero
>> FROM Member
>> WHERE UPPER(Member.FirstName) LIKE @LXListFirstName ESCAPE '\'
>> ORDER BY Member.LastName,Member.FirstName 
>>

>
>Thanks, it is good to know there are more than one way to do it. BTW, do you know if this way would be better to use than encapsulating the _ character between []?

I think it may be better in case you have [ in your query.