create table client (title varchar(100)) go insert into client values ('Michel F-ournier') DECLARE @Title Varchar(50) SET @Title='Michel F-%' SELECT * FROM Client WHERE Client.Title LIKE @Title