>>>>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...

thanks!