Archives of the TeradataForum

Message Posted: Sat, 30 Jan 2010 @ 10:43:00 GMT

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

Try this:

     SELECT INDEX (substring(column_x from (INDEX(column_x, ' ' ) +1)), ' ' )
     FROM database.table;

Regards,

HD

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