Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL question

Status
Not open for further replies.

athos07

Programmer
Aug 1, 2002
19
AU
select a_lastname, a_firstname, subject
from master
where subject = & "'*" & keyword & "*'"

this code in sql view in access still dosent work. what do you think is wrong with this code/statement.

it produce an error msg:

syntax error (operand missing) in query expression
'subject = & "'*" & keyword & "*'"
 
needs the like keyword

select a_lastname, a_firstname, subject
from master
where subject like & "'*" & keyword & "*'"
 
select a_lastname, a_firstname, subject
from master
where subject like & "'*" & keyword & "*'"

just receive your reply, thank you very much but i have already solve it. my code is this:

select a_lastname, a_firstname, subject
from master
where subject like '*' & keyword & '*'

BUT I REALLY THANK YOU FOR YOUR REPLY. HOPE I CAN RETURN A FAVOR. GOOD DAY

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top