SP return always 0 value

Question

i am trying develop login page , in that calling SP for validate the records , but it return always 0 .

 

please find the SP code here

 

CREATE PROCEDURE [DBO].[SP_LOGIN]

@USERNAME VARCHAR(50),

@PASSWORD VARCHAR(50),

@RESULT VARCHAR(50) OUT

AS

BEGIN

SET NOCOUNT ON;

SELECT count(*) FROM TBL_USERDETAILS WHERE USERNAME = '@USERNAME' AND PASSWORD = '@PASSWORD'

RETURN

END

 

Please give me proper solution