Improve SQL: NOT LIKE being repeated 3 times to filter out 3 different strings-CodePudding

Home > Mobile > Improve SQL: NOT LIKE being repeated 3 times to filter out 3 different strings

Improve SQL: NOT LIKE being repeated 3 times to filter out 3 different strings

Time：06-30

I am new at SQL so any help is appreciated. How can I improve on the following conditions in my where clause:

AND Upper(customer_name) NOT LIKE Upper('


          
          
            Page link：https//www.codepudding.com/Mobile/458869.html
          
          
               Prev:SQL: calculate the sum of each column and return them as rows
               Next:Dividing two SQL queries


  
    
      
        
          
             Tags：  
sql oracle-sqldeveloper               
        
      
    
  
 
    
      
        
        	
            	Related
            
                       
        
      
    
  

  
    
      
        
           Links：  
          CodePudding

            
      
    
  


  About Us:          Contact Us      Terms of Service      
Privacy Policy
  Copyright © 2010-2023，Powered By CodePudding