The following code returns

Code
*******
sql="SELECT * FROM CUSTOMERS " &_
    "WHERE CUSTOMERID ="
sql=sql & request.querystring("q")

Returns
*************
SELECT * FROM CUSTOMERS WHERE CUSTOMERID =NORTS
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.

I need it to return
SELECT * FROM CUSTOMERS WHERE CUSTOMERID ='NORTS'

It is missing the extra single quotes

The code should read

sql="SELECT * FROM CUSTOMERS " &_
    "WHERE CUSTOMERID ='"
'sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="
sql=sql & request.querystring("q") &"'"