Hi,
Our Development team just noticed that there were a few people where the standard salutation wasn't quite correct - in this case, people with the prefix "The Honourable".
If the prefix was "Mr", for instance, we could just use a Dear saluation of "Dear Mr Smith".
But you never say "The Honourable Smith". You would say "The Honourable Rob Smith".
Now, I can make a new salutation format without any trouble - what I wanted to know was if there was any easy way using SQL to change all our Honourables without having to go in, and right-click on the Gen. Sal. button on each record.
Or is that my only option?
Or if you can isolate the ones that need rebuilding into a list, you can run UP_REBUILD_SALUTATIONS. See this document for more information.