sql +sql reporting service

[Tank50]

Hi

I developed report using sql server reporting service.I used parameter to assign value for sql query.I want to use "LIKE" keyword in using parameter,How i do that?i wrote coding below what u wrote before.I used @con as parameter.

Select FriutID from Friut where friutName like'@con'%.

Once I write above coding it gave me syntax error message.

Thank
Tank50

[sknake]

Select FriutID from Friut where friutName like (@con + '%')

[Tank50]

Hi
Thanks for qucij reply.It works sknake.I need another help.I want to add sql statement like this

Select FriutID from Friut where friutName like' App%' or friuteName like 'or%' or etc ................

coz I add parameter as multiple values,so users ca select multiple values at once.So how I write above statemetn it using parameter.

Thanks
Tank

[Ramesh S]

Multivalue parameters cannot be used directly with LIKE operator in SSRS. You can do it only with workaround methods.

Try this link. Passing multiple values into parameter when using LIKE operator ( SSRS 2005)