Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simpleton
Starting Member
25 Posts |
 Posted - 2009-01-12 : 11:15:41
|
| I'm trying to build a SSRS report with an MSAccess datasource. Well, I need one of the parameters to be a wildcard so user's can type in text and get any results that have that portion of text in the field. How can I do a wildcard with a parameter?? Since it's MSAccess, I have to use ? as my parameter, but If I do this: AND (Comments LIKE '%?%')Then I just get every entry that has a literal "?" in the text. Any thoughts? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-12 : 11:16:53
|
| AND (Comments LIKE '%'+ ? + '%') |
 |
|
|
simpleton
Starting Member
25 Posts |
Posted - 2009-01-12 : 12:37:47
|
| Beautiful, thanks so much!!! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-12 : 12:38:56
|
| welcome |
|
|
|
|
|
|
Wildcard and Parameter for SSRS w/MSAccess