New to SQL and I'm having trouble with my Select Statement

[Staceyp]

I am new to SQL and I am running into error with my select statment.

When I try to check it with: response.write SQL
response.end

I get this:SELECT * FROM Registration WHERE Login='zoes'

My actual statement is:

SQL= "SELECT * FROM Registration WHERE Login='" & Replace(login,"'","''&quot & "'"

I am to new to see what the error is. Can anyone please help me?

Thank you

 

[listener22]

SELECT * FROM Registration WHERE Login='zoes' looks pretty good.
What were you expecting? Jim

oracle, vb

 

[Staceyp]

I just wanted to verify that that was the correct statement. As I stated before I am very new and wasn't sure what I should be recognizing. So thanks very much.