CASESPECiFIC
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
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