Archives of the TeradataForum

Message Posted: Fri, 24 Feb 2012 @ 10:56:47 GMT

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

There are various workarounds, none of which are pretty, the first one that comes to mind is creating a column that holds length of the string and using that in combination with your Natural Key to generate a "surrogate key"

So something like

     Select ' abc ' as key_col, CHARACTER_LENGTH (' abc ' ) as key_length


     key_col   key_length
     abc          5

Regards,

Irwing

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