>>>>

>>>>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.
>
>Neither is better

Hi Sergey,

What would you suggest if you want to have characters [\ _ in the search string? E.g. you don't know what @Search may contain?

I see you answered Michel, so I think I understand.

Thanks again.