Skip to main content
Question

how to filter on multiple items in message box (SQL)


Forum|alt.badge.img+5

I have the below line in SQL query where the user could write only one company or % for all. Is there a way to enable multiple values like we normally do in any view filter by ;?  I need this to be a parameter variable based on the user input and not fixed in the query itself.

 

COMPANY LIKE NVL('&COMPANY', '%')

 

regards

Housseiny

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings