0
format phone number after update
Hello,
how can I change a phone number that has been inserted using the 0049xxxxx format to +49xxxxx.
I need this to work on the trigger after update field.
I can select the first 2 digits using let codcat := substring(Phone, 0, 2); but I don't know how to have it updated into "+"
Thanks for any help
4 replies
-
replacex(Phone,"^00","+")
Content aside
- Status Answered
- yesterdayLast active
- 4Replies
- 28Views
-
2
Following