Insert a dash (-) after every 3 characters in a SQL column value.

Question

Sigiloso · Accepted Answer

SELECT 
    STUFF(ColumnName, 4, 0, '-') AS ModifiedValue
FROM YourTable
Example: ABCDEF → ABC-DEF
OR
SELECT 
    INSERT(ColumnName, 4, 0, '-') AS ModifiedValue
FROM YourTable

PwC

Pergunta de entrevista da empresa PwC

Resposta da entrevista

Empresas seguidas

Buscas de vagas