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

Question

Anonimo · 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

Domanda di colloquio di PwC

Risposta di colloquio

Aziende seguite

Ricerche di lavoro