I'm having problems in retrieving records with my query string. I'm trying to get all records that have the word 'Latex' anywhere in it. Can anyone help me?
Select * From Table where columnName like '%latex%'<BR><BR>That is how you would search a particular column for the word, are you wanting to return the row if *ANY* column last the word in it? Let me know<BR><BR>Nathan
select name from tblName where name like '%Latex%'
This will return any records that contain the characters 'latex'. If you want to specify the word, then use '% latex %'.
Okay thanks... I thought I was trying it before and it wasn't working... but it seems to work for me now... I guess I just mis-typed something.
Now, how would you do such a search using a stored procedure and retrieving a variable called frmKeyword obtained from an input box?
Help! (look in the thread)