Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2014 @ 13:00:58 GMT

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

Did you try with regexp?

Something like this

     SELECT REGEXP_REPLACE(columnname, '_', '', 1, 0, 'i');

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