>param.Value = "Michel'′Fournier"
>
Not sure about this one but I did try it. This gives the following command and doesn't find any record:exec sp_executesql N'SELECT Numero FROM Admin WHERE Admin.EmailName=@EmailName ',N'@EmailName nvarchar(40)',@EmailName=N'Michel''′Fournier '