asp classic - how to use vb variable in SQL statement in ASP? -

how use variables declared in asp vb can used in sql statement classic asp?

problem:

i have variable

dim username username = request.form("username") 

now want use variable in clause in sql statement shown below:

adors.source = "select * admin username=  //this want variable be.. 

what right syntax? thankyou

dim username username = request.form("username")  adors.source = "select * admin username= '"+username+"'"