Solved

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

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

734 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