Received: from nanguo.chalmers.com.au (gateway.chalmers.com.au [203.1.96.1]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA54331 for ; Tue, 1 Jun 1999 18:19:35 -0400 (EDT) (envelope-from robert@chalmers.com.au) Received: from carbon (carbon.chalmers.com.au [203.1.96.26]) by nanguo.chalmers.com.au (8.9.1/8.9.1) with SMTP id IAA02667; Wed, 2 Jun 1999 08:18:06 +1000 (EST) Message-ID: <009f01beac7d$1e86e900$1a6001cb@chalmers.com.au> From: "Robert Chalmers" To: , Subject: help??? Now I can't drop a renamed column.... Date: Wed, 2 Jun 1999 08:21:38 +1000 Organization: R.A.Chalmers Pty Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="_autodetect_all" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Ok, ok... I'm beginning to see some limitations here. Can't MODIFY a column name. as in ALTER TABLE tablename MODIFY existingColumnName CHAR( 24 ); So tried RENAME, and ADD COLUMN, and ended up with ISBN and XSBN fine. Now how do I get rid of XSBN.?????? Thanks for any pointers Bob --- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive! 4QIR Quantum Radio. Bringing you the original sounds of AFVN, with some of the original DJ's - back on air - and supporting not only the original Vets, in comprehensive AFVN Archives, but putting together segments for the fighting men and women of todays services all around the world. World Music, for people of the world.