title: how to use vb variable in SQL statement in ASP?
body: <p>How to use variables declared in the asp VB can be used in the SQL statement for classic ASP?</p>
  
  <p>Problem:</p>
  
  <p>I have a variable </p>
  
  <pre><code>dim username
  username = Request.Form("username")
  </code></pre>
  
  <p>Now I want to use this variable in where clause in the sql statement as shown below:</p>
  
  <pre><code>adoRS.Source = "SELECT * FROM admin WHERE username=  //This is where I want this variable to be..
  </code></pre>
  
  <p>What is the right syntax? Thankyou</p>