how to use variable in sql query

[amir]

hi all
i m using a query

objrs1.Open "select * from course where username=" & studentid & "",objcon,1,2

where studentid is a variable having students usernames coming from database.
this query does not work for me, an error comes

Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/login/login.asp, line 14, column 52
objrs1.Open "select * from course where (username=" studentid ")",objcon,1,2

[TheShaner]

if studentid is a number:
objrs1.Open "select * from course where username=" & studentid,objcon,1,2
if studentid is text:
objrs1.Open "select * from course where username='" & studentid & "'",objcon,1,2
To be honest it's cleaner to do (assuming studentid is a number):
query = "select * from course where username=" & studentid
objrs1.Open query,objcon,1,2
-Shane