How do I insert a variable into an SQL LIKE statement? ex.

SELECT * FROM Issues WHERE Issue LIKE '%[variable]%' ?

I want to match a variable pattern occuring anywhere in a string.

Thanks,

casox