Solved

How to use like operator in parameter field with multiple entries?

Posted on 2004-04-08
4
700 Views
Last Modified: 2008-02-01
I m using database oracle, operating system is win 2k.
I want to use like operator to retrieve the multiple records against multiple Employee Names but like operator works fine in case
of one employee name and this input i m getting from parameter field,
but now i want to do same thing but for more then one employee names (with multiple entries or multiple employee names)

How to use like operator in parameter field with multiple entries?.
0
Comment
Question by:anupnellip
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 300 total points
ID: 10782258
Hello anupnellip,

I don't believe that you can use the Like operator with a multivalue parameter.
You could select multiple specific values from a list of employees and this would work:

Create a parameter field which allows multiple entries ?MyPar.
In the record selection formula :

{Mytabl.Myfield} in ?Mypar

Pete
0
 
LVL 10

Author Comment

by:anupnellip
ID: 10782466
Thanks Pete

I have already done this
but our scenario is slightly different

In case of IN it will look only for those specific values from the Parameter list,
but we want to get similar values as well which is starting from may be
For example
Smith...
Sm..
Smi..

Like operator is working in case of only one entry but not in the case or more then one value.
0
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 200 total points
ID: 10783005
I believe Pete's correct that you can't use 'like' with a multivalue parameter.

If you want to do this then you would probably have to accept the parameters and pass them to an Oracle stored procedure and then use the sp to produce your dataset.

frodoman
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 10783491
I agree with the analysis.  The IN operator is from Set theory so it checks for equality.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now