Archives of the TeradataForum

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

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

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

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