Saturday, September 25, 2010

Purpose of CASESPECIFIC in teradata

Casespecific function in teradata is used to get excat value  say  for  example .product code 'Rac123Sa'  .

SELECT  product_code
FROM product_tab
WHERE product_code (CASESPECIFIC) LIKE '%Ra%';

Note: Usually the comparison  in teradata is not case-specific. To enforce CASESPECIFIC , we use CASESPECIFIC function

No comments:

Post a Comment