Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 11:32:00 GMT

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

I tend to cheat with one of these :

     select cast('hello' || 'world' as char(10)) from (select '1' as myone ) as mydual;

     select cast('hello' || 'world' as char(10));

_______________________
Dave Clough
Database Designer
Express ICS

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