Solved

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

Posted on 2004-04-08
4
702 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

790 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