Re: Case Insensitive

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 28 Mar 2019 03:29:55 -0500



    On 3/28/19 3:23 AM, Sameer Kumar wrote:

    [snip]

    
          You can write a
            query with upper function:
          

          select * from
            emp where upper(ename)=upper('aaa');
        
      
    That's a guaranteed table scan.

    
    -- 

      Angular momentum makes the world go 'round.