I'm not clear on your requirements, but this post may help you: http://dataqueen.unlimitedviz.com/2011/06/how-to-default-to-all-in-an-ssrs-multi-select-parameter/ John

Can somebody tell me how to implement wild card search functionality in SSRS Reports..I have built a simple report and need to provide this functionality..please if somebody can point me in direction of some tutorial or something it will help a lot..Thanks a lot in advance

Thank you guys for your input..It has given me the proper direction :)

In your sql where clause do one of the following Where <field> like @parameter_value + '%' <--- Starts with Where <field> like '%' + @parameter_value <--- Ends with Where <field> like '%' + @parameter_value + '%' <--- Contains