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.