05-21-2014, 07:06 AM
Ekim Wrote:You need to set a condition for your statement. to change only the needed rows.
I do not know what condition I should set. All I need is to change the Record Numbering from CON01 to CON00001 for multiple contacts at once. The first SQL query provided by Joe works but then for the UPDATE query I am not sure what condition I have to put.