Archives of the TeradataForum

Message Posted: Tue, 14 Mar 2006 @ 12:17:47 GMT

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

Hi Ankit,

     substr('Teradata Warehouse',1,index('Teradata Warehouse',' ')-1)

This will give the Teradata as output, you can use the index function and substr function with combination.

Thanks and regards,

Dhanabal S.
Teradata DBA

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