Variable names in SQL
My VBA code has an SQL statement to call. I'm assigning the statement to a
string variable and use this variable to call it later. The statement has a
condition (the "where" clause) that needs to compare a column name to
another variable's value.
What is the syntax for this? For example:
testvalue="boo"
sqlstring="select * from mytable where mycolumn=testvalue"
How do I mark testvalue in the select string?
|