ASP and SQL
Posted on 2004-09-10
I'm trying to run a SQL statment, mixed with some VBScript. HEre is my code:
mySQL = "select empid from a_employee" & _
"where empfirstname + ' ' + emplastname = " & " ' " & Tim Tester " ' "
When I try and submit the asp page, it comes back and tells me that it doesn't like the + sign. If I were doing this in a SQL Query window, it works fine...see my regular sql statement below. But for some reason, ASP doesn't like it.
select empid, empfirstname, emplastname from a_employee
where empfirstname + ' ' + emplastname = 'Tim Tester'