Hello, It says no question is too simple here so here goes. I need to put a variable into my WHERE clause in a SELECT statement. eg:<BR><BR>a = 0<BR><BR>sql = "SELECT * FROM table WHERE field > a"<BR><BR>I need to know the correct code. I'm sure it's simple but I can't find it anywhere. Thanks in advance.