troubleshooting Question

use regexp_like with multiple values

Avatar of W D
W DFlag for United States of America asked on
Crystal ReportsOracle Database
11 Comments3 Solutions6221 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros