Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT_WS('-', CONCAT_WS( '-', SUBSTRING(ACCOUNTNUMBER, 1, 2), SUBSTRING(ACCOUNTNUMBER, 3, 2)), SUBSTRING(ACCOUNTNUMBER, 5, 4))
- FROM BILLING.ACCOUNT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement