I can get it to match the exact phrase but can i get it to match a bit for example if the user types CT i want that to bring up ct head, ct skull etc?

At the moment the query is this and only selects everything it is equal to; SELECT exptosql201213.* FROM exptosql201213 Where @FreeTextSearch = ExamName

Hi All Is it possible in SSRS Reporting Services 2008 to add a text box to a report and get that to act like a parameter, selecting all those records that match whatever is entered into the text box? for example if someone enters "aneurysm" into the text box i want to return ever row fro ma particluar column called Report Text in my database that contains that word, like a wild card search? I'm new to the expression so if anyone could walk me through how to go about this I'd be really grateful. I thought maybe add a datasource that looks to the database, then add a select all statement in the datset to extract all the rows. Then add a text box to the report and add a look up expression to match whatever is writeen in Textbox 11 with what is in the report text column of my dataset, return 4 columns, name, DOB, Number, and report text. Any advice you can give would be really appreciated :) Cheers Dave B

It should work like the search box on the toolbar of SSRS, instead of highlighting the rows though it selects them?

I see how I can create a free text parameter but it doesnt seem to filter the data in any way. Normally I would bind the values to a dataset but in doing so it prevents you entering things free text? I need the user to be able to write what they like and match it up with that phrase in the data? Any ideas, thanks for your response; Cheers :) Dave B

Sorry just realised what you meant, I had to match the paramter to the freetext in the query! Thanks for helping me realise :)!