Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2014 @ 10:38:04 GMT

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

Hello Everyone,

I have requirement to replace the ?_? to none, for example:- ??6_in_6? to 6in6

Tried with oreplace but not working.

     SEL oreplace(COLUMNNAME,'_','|') FROM? DATABSASENAME.TABLENNAME

Any idea

Regards,

Sri

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