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
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
Thank you :
- kareem