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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.