"LIKE %" AND "@PARAM"

[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'%'

[gpl]

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

[vag]

Thank you very much Graham!
That worked indeed.