Archives of the TeradataForum
Message Posted: Tue, 02 Sep 2014 @ 10:38:04 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|