select t3, '( ' || SUBSTRING(CAST(t3 AS VARCHAR) FROM 1 FOR 4) || ' ) ' || SUBSTRING(CAST(t3 AS VARCHAR) FROM 5 FOR 3) || '-' || SUBSTRING(CAST(t3 AS VARCHAR) FROM 8 FOR LENGTH(CAST(t3 AS VARCHAR))) || to concentate between 2 strings or more
select t3, '( ' || SUBSTRING(CAST(t3 AS VARCHAR) FROM 1 FOR 4) || ' ) ' || SUBSTRING(CAST(t3 AS VARCHAR) FROM 5 FOR 3) || '-' || SUBSTRING(CAST(t3 AS VARCHAR) FROM 8 FOR LENGTH(CAST(t3 AS VARCHAR))) || to concentate between 2 strings or more