DECLARE @Title Varchar(50) SET @Title='Michel F%' SELECT Client.Numero FROM Client WHERE Client.Title LIKE @Title...it will find all records having a title starting with Michel F.
DECLARE @Title Varchar(50) SET @Title='Michel F-%' SELECT Client.Numero FROM Client WHERE Client.Title LIKE @Title...it will not find anything, even if I have some title starting with Michel F-ournier, for example.