Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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'.


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