About use like

[gustavozm]

I'm using one as not SELECT but no return.

So: p.name = '% @ prod%'
Where prod would be a parameter.

Unsuccessfully.

Can you help me?

[tomyeh]

Don't put space between @ and prod.

[gustavozm]

I got it. Thanks.