string parameters in command

[Dimitrie1]

I have a string parameter called PlaceName

this works for single value p.Name = '{?PlaceName}'

but I want a multi select and this is erroring AND p.Name IN '{?PlaceName}'
I've also tried AND p.Name IN ('{?PlaceName}') and it errors too

help please

Linda

 

[lbass]

If I’m remembering correctly, for multiple value string parameters, you need to remove the quotes.

-LB

 

[Dimitrie1]

Thanks I'll try that.

 

[kray4660]

I have always had issues with multiple value and strings in a command. Seems to me that I read that you have to do the equivalent of a Crystal Reports Join function (I do not recall currently how to do it).