REPLICATE function?
Posted: Wed Oct 30, 2013 1:58 pm
Is there a REPLICATE function in Vertica similar to the one in MS SQL Server?
Example from my SQL Server DB:
Example from my SQL Server DB:
Code: Select all
USE AdventureWorks2012;
GO
SELECT [Name]
, REPLICATE('0', 4) + [ProductLine] AS 'Line Code'
FROM [Production].[Product]
WHERE [ProductLine] = 'T'
ORDER BY [Name];
GO
Code: Select all
Name Line Code
-------------------------------------------------- ---------
HL Touring Frame - Blue, 46 0000T
HL Touring Frame - Blue, 50 0000T
...