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