Special Chars in SroredProc Variable

See more:

SQL-Server-2005

C#

SQL-Server

, +

Hi,
Good morning and thank you for your help. I have the following C# code:

userid =@"Master\%Clow%";
cmdGetSqlResult.CommandText = "dbo.GetResultsBasedOnUserID";
cmdGetSqlResult.Parameters.AddWithValue("@MYID", userid);

and the GetResultsBasedOnUserID Stored Procedure looks like below:

SET NOCOUNT ON;
@MYID Char(20)
Select * from XYZtable Where userid = @MYID

When I run it in the Query window of SQLServer MGMT Studio as below,

Select * from XYZtable Where userid = ‘Master\%Clow%’

it works, but if I send the value as a stored proc value from C#, it does not work. Would you please help me solve this issue?

Advanced thank you for your help.