Any one have a script or SQL function for this? Pretty sure I can write one, but I'm sure to mess it up at least once. Hoping one already exists out in the world.
-Levi
Were you able to figure something out with this?
Hi Courtney,
An oldie but a goodie (from 2 jobs ago!)
I think in the end I manged to talk the users out of whatever it was they were planning in favor an alternative way of marking what they wanted. Honestly can't recall what the specifics were.
The tricksy bit was going to be figuring out how to insert a mail purpose value into something that already had some values marked. Since all 10 mail purposes are stored as a single string of characters in one field I wasn't excited about having to write some weird concatenation rules for over half a million address records.
I haven't looked in our test environment yet, but I'm excited to see how the contact purposes are handled.
- Levi
I had a feeling it was something that could not be done easily, but thanks for the follow-up!
We have a function that could possibly help you with this. I would be happy to share.