DECLARE @Variable AS VARCHAR(50)
DECLARE @NbChar AS INT
DECLARE @Separateur AS VARCHAR(3)
SET @Variable = 'ABCDEFGHIJKLMNOPQRSTUVXYZ'
SET @Separateur = '...'
SET @NbChar = 3
SELECT
LEFT(@Variable, @NbChar) + @Separateur + RIGHT(@Variable, @NbChar)
AS RESUME;