Most of the time, I use the latter option and have the account names copy from the exiting accounts.Here is an example of a list of account numbers for the Sales department (first segment 300) in the Dynamics GP sample company: If you copy all of these accounts to create a new accounts for the Marketing department (first segment 350) choosing ‘Use Account Description From Existing Accounts’ the account numbers will be new, but the account names will still be the same: Using REPLACE in SQL Server, you can quickly update the account names to reflect the correct department name.I have seen this come up in a variety of situations, like needing to change account names in the General Ledger or needing to show something differently when reporting.The basic code is as follows: Below is a practical example of how useful this can be.
You use an update query when you have to update or change existing data in a set of records.
This blog covers using the REPLACE function to selectively replace text inside a string in SQL Server.
The REPLACE function is easy to use and also very handy with an UPDATE statement.
Note: You cannot run an update query in a Web browser.
If you want to run an update query in an Access Web database, you must first open the database by using Access. If you are using an Access web app, you can use data macros to update or change existing data in a set of records.