Query DataSource Syntax

I have created a custom filter that is connected to a query datasource. I don't seem to be able to use a stored procedure with a custom filter, so I have changed it to inline sql in the datasource webpart.

I was passing a parameter to the stored proc which I now need to include in the in-line sql.

I need to do something like this (except this is not working)

where (NodeAliasPath like '%'##WHERE##'%')

It seems to be evaluating correctly, but the syntax is not correct.

Can someone help me with this.

Thanks.