Solved

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

Posted on 2004-04-08
4
706 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 101

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

617 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