I am a new joiner, so this forum is going to be very helpful for me.
This is probably something very easy, but I am looking to replace the end of a string e.g. Replace 'Dun and Bradstreet Inc.' with 'Dun and Bradstreet Incorporated' in Access using an Update Query, but no luck.
Also, if I have many records like this eg. Inc. to be replaced with Incorporated, plc with Private Limited Company etc., at the end of a string (or even within a string) how do I do it?