0

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

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by Ramesh S
0

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

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.