I have string (varchar) and I am looking to replace 3rd and 9th position of the string with ‘$’ and ‘#’, on Microsoft SQL Server STUFF function will perform string replacement. Do we have any equivalent functions on Teradata? I gave a try with oreplace, but it is not handy to identify string postions and substring aslo not helpful.
Actual string value = AAABXXCYY
Expected string value =AA$BXXCY#
If it's always the third and ninth position in the string, use this...substring(columnname from 1 for 2)||'$'||substring (columnname from 4 for 5)||'#'.