Substitute for Function STUFF (SQL Server) in AWS redshift – Amazon Web Sevices
I have to replace first 3 digits of a column to a fix first 3 digits (123) Working SQL Server code. (Not working on AWS RedShift) Code: Select Stuff (ColName,1,3,'123')as NewColName From DataBase.dbo.TableName eg 1 -Input --- 8010001802000000000209092396---output -1230001802000000000209092396 eg…