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

Question

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

PwC interview question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches