Problem With The SELECT Statement Of The Stored Procedure In String Comparison.

 

Hi all,
I have created this simple Stored procedure. But it gives me wrong result when I  pass a parameter to it. But if I hard

code it, it gives me the right result.

The I check if the field value of 'Email' is exactly equal to  the parameter '@Email'.

The field 'Email' is varchar, and CID is integer.

CREATE PROCEDURE EmailExists @Email varchar
AS
SELECT CID
FROM Customers
WHERE Customers.Email = @Email
return

Instead, if I check the value directly, it gives me correct answer.
The the following code works fine when I typethe Email directly in the code.

CREATE PROCEDURE EmailExists @Email varchar
AS
SELECT CID
FROM Customers
WHERE Customers.Email = 'tomyseba@yahoo.com'

return

Can anyone tell me the reason for it.

Thanking you in advance

 

Tomy