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