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...will find all records having S as the first character and SH for the 3rd and 4th character no matter what is the second letter. So, it found results such as: