Might be I'm wrong, but I don't htink you can compare varaible without value to result of select. I meant

IF @tmpPasswordRtrv = (SELECT strPassword FROM Users WHERE lUniqueID = @lUserID)

and

IF...

Usually in cases like this I use double quotes to identify the text.  All comas within quotes are recognized as part of text.