Sample Header Ad - 728x90

How to format String with a pattern

1 vote
2 answers
15166 views
I want to format my string in my select statement but I cant seem to find the syntax for this pattern. I have a column of card_num with 16 digits and i want to have a dash(-) after the first four digits. Original card_num: 1234567891234567 Desired output: 1234-567891234567 I think regex can do this but cant find elsewhere the right code for this pattern. Any idea how to do this? Thanks.
Asked by Blank (71 rep)
Aug 27, 2017, 07:06 AM
Last activity: Aug 27, 2017, 08:57 AM