RE: ASP and SQL Error - expected end of statement

[vistor]

Durug,

Sorry I forgot to ask this earlier. Would I add a LIKE to the query as follows:
Original:
sqlQ = sqlQ & " WHERE Employee.last_name = '" & Request("txtlast_name&quot & "'"

Change to:
sqlQ = sqlQ & " WHERE Employee.last_name = LIKE "*" & '" & Request("txtlast_name&quot & "'"

CDWD

 

[durug]

sqlQ = sqlQ & " WHERE Employee.last_name LIKE "'%" & Request("txtlast_name&quot & "%'"

will return

Ana
Aspen
Armenica
Penta

if request("txtlast_name&quot = n

if you wnat to return only
Ana
Aspen
Armenica
when request("txtlast_name&quot = a
then you should delete the first "%" sign

Hope it helps,
Regards,
Durug