>>
>>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.
If it's not broken, fix it until it is.
My Blog