Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 May 2002 @ 17:34:40 GMT


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


Subj:   Re: RANK Function ... Sorting
 
From:   Geoffrey Rommel

William, your description of the problem is a little obscure, but the key seems to be this:

  In a text sort 'YIELD_IND_CD' would come before 'YIELD_INDEX' which is what I expected.  



This would be true in EBCDIC but not in ASCII. In ASCII, the underscore is higher than the upper-case letters: the letters occupy the code points x'41' - x'5A', and the underscore is x'5F'. 'YIELD_INDEX' would therefore sort before 'YIELD_IND_CD'.


--wgr



     
  <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: 27 Dec 2016