If I want the year and month I would need to add the right and left. correct
UPDATE [EC_StoreAttributes]
SET AttributeValue = RIGHT(CONVERT(VARCHAR(10), GETDATE(), 101), 2) +
SUBSTRING(AttributeValue, 3, LEN(AttributeValue) - 4) +
left(CONVERT(VARCHAR(10), GETDATE(), 101), 2)
WHERE
AttributeType = 'ECSRCCODE' and StoreRecordId = '1'