Old chat I know, but it helped me and allowed me to find another "quirk" I guess....

We have Report Builder 10, and it is fine with "LIKE". I use parameters with it to get Starts with or Contains.

In Select statements if you want "Starts with" I use LIKE @Parameter + '%'

But I did discover that to use it for "Contains" instead of "Starts With", I wasn't getting any results with

LIKE '%' + @Parameter + '%' as you would expect to do. I think it may be ok if you wanted text inside a word, but in my case the "Contains" may be second word in a name, after a space.... eg Mt Everest.

I found when I added a second wildcard eg. LIKE '%' +'%' + @Parameter + '%' it worked!