I just started working with calling stored procedures through my asp pages. I am testing one right now and not having any luck. Right now I want to test it where a user enters just a login name, the pages passes that login name to the stored procedure, the procedure runs, then a message displays that it either passed or it didn't. I can get this to work if I am passing just a number to the stored procedure, but I am having a problem with a string being passed. Here is the code from my asp page:<BR><BR>sql = "usp_LOGIN ('" & Request.form("txt_username") & "')"<BR>rs.open sql,conn, 0, , 4<BR><BR><BR>Here is the test stored procedure I am trying to get to work:<BR><BR>CREATE PROCEDURE usp_LOGIN<BR>(<BR>@LoginName nvarchar<BR>)<BR>AS<BR>SELECT LOGINNAME FROM HQ_USERS where LoginName = '@LoginName'<BR>GO<BR><BR>Am I missing something?