First of all I don't normally use SQL, so please excuse my ignorance.
1st Query
We have a table with a column with data that looks like this:
AMTL03256636
What I need to do is change the AMTL portion of the column to another set of
charachters i.e TEST
Currently i'm extracting the data, loading it into excel changing the data
and then bulk inserting it back
into the SQL7 table. Is there away to change the AMTL without the other
steps?
Alan