>>>I am trying to use wild cards infront and behind a variable in a select-sql statement. Apparently this does not work. Does anyone have any suggestions? Thanks for the help
>>
>>The '%' symbol works for this (it's a little finicky in macros, you have to get the quotes right).
>
>I guess that is my question. What is the right way to use the quotes?

you can set variable before SQL, x = '%' + x + '%'
then put the macro in quotes, like '&x'
that's one way...