Hello All,
We understand that the format of a phone number depends on the address country for address phone numbers and the system default country for non-address phone numbers.
Any interesting ways around this for non-address phone numbers?
We do not attach any phone numbers to addresses, and we do have a number of records where the constituent's mailing address may be in the U.S., but they also have an oustide-the-U.S. phone number that we'd like to format properly.
Not sure what context you're looking to use this in, but you don't have to use the TR_COUNTRY phone masks in your code directly, e.g. this works:
dbo.AF_FORMAT_STRING(pp.homephone, '(@@@) @@@-@@@@ X@@@@')
... between the ' ' you can make the mask anything you want.