If I have a select like this:

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.

But, if I have this:

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.

I assume there is a conversion that has to be done on such special character.