Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use "like" in parameters

Status
Not open for further replies.
kyzina

kyzina

Technical User
Mar 10, 2009
38
US
Users want to be able put the not exact value in the prompt.
Please advise. thank you
 
Sort by date Sort by votes
Hi,
In your selection formula use:

{Table.Field} LIKE *+{?Parameter}+*




[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Upvote 0 Downvote
Thank you so mush. It's a miracle!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
246
AleXSR700
AleXSR700
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
318
mmck1964
mmck1964
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
379
hilfy
hilfy
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
213
jchewsmith
jchewsmith
AleXSR700
  • Locked
  • Question
How can I make variable that is re-defined per section and readable in same-section formula? 2
2
Replies
20
Views
481
AleXSR700
AleXSR700

Part and Inventory Search

Sponsor

Back
Top