Sunday, January 30, 2011

Is Like comparison case-sensitive in Teradata?


Is Like comparison case-sensitive in Teradata?
Answer

LIKE operator is not case sensitive in Teradata session mode.
Consider the following example  
Select F_name from employee where F_name like '%JO%’;
The following query will pick values matching with 'JO' and 'jo' as well, since Teradata is not case-sensitive

To overcome this problem, a new function called "CASESPECIFIC" is used in TERADATA as follows
Select F_name from employee where F_name (CASESPECIFIC) like '%JO%’;

2 comments:

  1. Great Job! Really Thanks for your efforts.
    Is this website is only for informational purpose..
    How do I trade on the stock market?
    Sensex
    Sensex

    ReplyDelete
  2. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. 裁判判例と未解決事件データベース

    ReplyDelete