Avatar of W D
W D
Flag for United States of America asked on

use regexp_like with multiple values

Hi, I have the following SQL (we use Oracle) in my Crystal Reports command object:

WITH
 full_narr AS(
SELECT
 it.order_proc_id
, it.line
, it.narrative  narr_impression
FROM impression_text it
WHERE regexp_like(it.narrative,'{?Keyword}','i')
)

How can I use regexp_like to allow multiple values? Do I need to write multiple OR statements?
Oracle DatabaseCrystal Reports

Avatar of undefined
Last Comment
W D

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Sean Stuber

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
W D

ASKER
Wow! Thanks for all of the promp replies!! Er, yes, sdstuber, I would like multiple key words to be found. Didn't know one could use the pipe operator. Since you were first, sdstuber, I will award points to you. Many, many thanks to both slightwv and mankowitz for your comments.
Kurt Reinhardt

SQL does not allow multiple value input parameters.  That being said, if you have Crystal Reports 2008 or 2011 then you can use multiple value input parameters with SQL Commands, because SAP has basically built in functionality that converts the list of values selected by the user into an array of values that SQL can read.

If you're using XI R2 or lower, please see this example report I've written that demonstrates how to use Multiple-value parameters with SQL Command objects:

https://www.box.net/shared/663ziq8unr
Sean Stuber

glad to help, both slightwv and mankowitz were within a couple minutes though, close enough that I'm willing to call them all effectively "simultaneous".  I'm ok with splitting the points with them
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
W D

ASKER
Re: I'm ok with splitting the points with them
ah, ok, sdstuber, that's very kind of you.
Since the points are already awarded, I'll contact the Expert's Exchange editors to have them update the points.
slightwv (䄆 Netminder)

sdstuber and myself are both Zone Advisors and can unaccept this if you wish.

Personally, I'm OK either way.  Just let us know your wishes.
W D

ASKER
Re: slightwv and I are both Zone Advisors
Ah, good to know! I was just trolling around the site trying to figure out how to contact customer service. thanks for reopening the question for me again, sdstuber.

Regards,
w delaney
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Sean Stuber

no problem,  but, if you ever do need to get help on a question scroll to the top,  just under the question window itself there is a "Request Attention" link.

That will open a thread with the moderators to assist you.
W D

ASKER
Thanks, sdstuber!! :)