it was a typo from when I added the code - any ideas on how I can get 
around this?

Many thanks
> There is no comma between the first column you are updating and the 
second.
> 
> Or was that just a typo when you added the code to the post?
> 
> Imar
> 
> At 01:19 PM 4/17/2001 +0000, you wrote:
> >I've been trying for ages to update a table with this bit of code:
> >
> >UPDATE location
> >SET        location.LC_NORTHING = postcode.PC_NORTHING
> >            location.lc_easting = postcode.pc_easting
> >WHERE      location.lc_postcode_out = postcode.PC_POSTCODE_OUT
> >AND        location.lc_postcode_in = postcode.PC_POSTCODE_IN;
> >
> >
> >
> >and keep getting either of these error messages:
> >
> >"Invalid column name" or "SQL command not properly ended".
> >
> >Could someone please tell me where I'm going wrong (the column names are
> >all valid)?  I'm using oracle 8.5.
> >
> >Many thanks in advance.
> >E.Ukwu
>