Advertisement
gem7726

Untitled

Jan 16th, 2019
505
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. SELECT CONCAT_WS('-', CONCAT_WS( '-', SUBSTRING(ACCOUNTNUMBER, 1, 2), SUBSTRING(ACCOUNTNUMBER, 3, 2)), SUBSTRING(ACCOUNTNUMBER, 5, 4))
  2. FROM BILLING.ACCOUNT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement