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