Re: query to delete last record of a table

cricketunes_at_yahoo.com wrote:
> How can i find the highest value when the available values are C1, C2,
> C3....C10?
>

You don't even have a decent primary key... Do not ever, never ever, NEVER put *codes* in your keys.

How do you update the numerical part, anyway? Use that, and construct the primary key similar to what you do upon inserts

-- 
Regards,
Frank van Bortel