SQL string help

Could someone please tell me what is wrong with this:

SQL="SELECT * FROM tblLogin WHERE ID='" & request.cookies("login") & "';"

Its probabley really simple becuse if you use SQL="SELECT * FROM tblLogin;" it works.

Thanks, mart.

Ps this is the error I get

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/db/user.asp, line 13

Thanks for that, I tried it but now I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.

/db/user.asp, line 13

(Id is a autonumber)

Thanks, Martin.

Thanks for that ljamal, I have made it check for a null cookie now.

Mart.