05-21-2014, 08:49 AM
joebordes Wrote:If you want to change all the records, completly eliminate the where condition, if you want to change a subset of the accounts then you put a condition the selects that subset. In other words I was trying to say that you can add a condition there to change only some records, not all.
Understood and thanks. Forgive my ignorance in SQL!
Unfortunatly after applying the UPDATE query without the condtion (as I need to apply the change to all the records) I ended up with the account_no column being like so: 000G1, 000G2 etc etc
[attachment=0]<!-- ia0 -->account_no.gif<!-- ia0 -->[/attachment]