create delimiter for the phone number

PHOTO EMBED

Fri Mar 18 2022 04:21:42 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

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

content_copyCOPY