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