Skip to content
Advertisement

Teradata REPLICATE function?

I’m converting MS SQL Server codes to Teradata. I found out that Teradata has no replicate function. Below is the sample code

REPLICATE('0',2-LEN(CAST(COLUMN_NAME AS NVARCHAR)))

Is there an alternative function for replicate in Teradata?

Thanks

Advertisement

Answer

Try this:

SUBSTR('00', 1, 2-CHARACTER_LENGTH(CAST(COLUMN_NAME AS VARCHAR(10)))

This will repeat the character '0' two minus the length of the column, which is effectively doing the same thing as REPLICATE in SQL Server.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement