CREATE VIEW dbo.BARKOD_SIRALI_KAYIT
AS
SELECT        QQ.LOGICALREF, QQ.SIRA, QQ.EXPCTGNO, CASE WHEN LEN(QQ.SIRA) = 1 THEN CONCAT('UNI-0000', SIRA) WHEN LEN(QQ.SIRA) = 2 THEN CONCAT('UNI-000', SIRA) WHEN LEN(QQ.SIRA) = 3 THEN CONCAT('UNI-00', SIRA) 
                         WHEN LEN(QQ.SIRA) = 4 THEN CONCAT('UNI-0', SIRA) WHEN LEN(QQ.SIRA) = 5 THEN CONCAT('UNI-', SIRA) END AS BARKOD
FROM            ((SELECT        LOGICALREF, EXPCTGNO, ROW_NUMBER() OVER (ORDER BY LOGICALREF) AS SIRA
FROM            LG_011_ITEMS)) QQ