In Code Behind, What is proper select statement syntax to retrieve the @BName field from a table?
Using Visual Studio 2003
SQL Server DB

I created the following parameter:
Dim strName As String
Dim parameterBName As SqlParameter = New SqlParameter("@BName", SqlDbType.VarChar, 50)
parameterBName.Value = strName
myCommand.Parameters.Add(parameterBName)

I tried the following but get error:
Dim strSql As String = "select @BName from Borrower where BName= DOROTHY V FOWLER "

error is:
Line 1: Incorrect syntax near 'V'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'V'.

Source Error:


Line 59:
Line 60:
Line 61: myCommand.ExecuteNonQuery() 'Execute the query