Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2012 @ 16:39:09 GMT

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

Can you use CHAR()?

     SELECT char('123');

Another approach might be to to use Index:

     sel index('123'||'~','~') - 1;

Johannes de Wet
Unum

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