Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 13:25:14 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Case sensitivity modifier in IN clause
 
From:   Michael Larkins

There is no need to use the CS or NOT CS on both sides of the comparison operator. If one side is CS, both sides are the same. It is a single comparison. So, putting the attribute of CASESPECIFIC on the column name is sufficient and this works fine in all releases.


This will fix your issue.

Michael Larkins
Certified Teradata Master



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023