Hi, I'm having a SQL database problem. I have a table called roleslookup containing just one field role. If I use the following code:<BR><BR>...<BR>Dim addedrole<BR>addedrole = Request.Form("confirmrole")<BR><BR>existQuery = "SELECT Role FROM roleslookup WHERE Role = '" & addedrole & "'"<BR>...<BR><BR>When existQuery is executed it returns an empty recordset even if addedrole is equal to a Role in the table. Why is this happening ? Is it due to there being only one field in the database or is my syntax incorrect ?<BR><BR>Hal.