![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 31 May 2002 @ 17:34:40 GMT
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
| |