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

Question

Anónimo · 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

Pregunta de entrevista de PwC

Respuesta de la entrevista

Empresas seguidas

Búsquedas de empleo