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 |
|
itswhit
Starting Member
2 Posts |
 Posted - 2006-02-22 : 15:39:49
|
| Is there a way to do a parameter in the report for like part of a name?In sql views you use Like %whi% to search for any records containing whi. Is there any way to create an input parameter for you to type any part of a word in and have the report bring the records back pertaining to what you typed in??John Whitmer |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-22 : 15:47:59
|
| You would restrict the rows returned from SQL Server (or whatever your data source is) using LIKE in the query.Tara Kizeraka tduggan |
 |
|
|
itswhit
Starting Member
2 Posts |
Posted - 2006-02-22 : 15:53:08
|
| I found it!WHERE Description like '%' + @Description + '%'John Whitmer |
|
|
|
|
|
|
LIKE parameter