"LIKE %" AND "@PARAM"

This is going to be easy for any of you who is experienced.
What is wrong with the following query?

Select Company from Generalview Where Company Like '%'@.search'%'

Quote:

Originally Posted by vag

This is going to be easy for any of you who is experienced.
What is wrong with the following query?

Select Company from Generalview Where Company Like '%'@.search'%'

You are searching for fields whose literal value is '@.search' (ok, it isnt as it is not a valid string ... try this

Like '%' + @.search + '%'

Graham|||Thank you very much Graham!
That worked indeed.