>>Can you look at the exact command being sent from .NET? Fire up SQL Profiler before executing your code.
>
>This is my test environment:
>
>
>exec sp_executesql N'SELECT Numero FROM Admin WHERE Admin.EmailName=@EmailName ',N'@EmailName nvarchar(40)',@EmailName=N'Michel′Fournier '
>
>
>Between Michel and Fournier, there is the Prime character. I can see in the SQL Profiler that this is being displayed as a square box meaning that it cannot display it.
>
>In the SQL Profiler, we can see that it uses the N syntax for the value. Do you see anything wrong in there?
I would double the quote
param.Value = "Michel'′Fournier"
Gregory