>If you now grab that command from profile and try running it, I guess you will not get results.

That is exactly that. And, the most frustrating part is that I can go in SSMS and execute the following:

select * from Admin where EmailName='Michel’Fournier'

That would work.

So, SSMS has something built in that negotiates with that pretty much easily.

>Looks like the prime character is being lost before sent to SQL Server. What is the declaration of the parameter in .NET?

NVarChar