RE: Altering fields

You would have to create a UDT. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche >From: "Malcolm Weallans" <MWEALLANS@lqgroup.org.uk> >To: "Malcolm Garbett" <malcolm.g@newall.co.uk>, "Ids \\\\(E-mail\\\\)" ><ids@iiug.org> >Subject: RE: Altering fields >Date: Mon, 13 Jan 2003 16:34:29 -0000 > >No, it is not possible. You can't have anything other than numerics in >a serial column. You could use two columns, one character (2) with a >default value of "NM" and a serial column. > >regards > >Malcolm (another one!) > >-----Original Message----- >From: Malcolm Garbett [mailto:malcolm.g@newall.co.uk] >Sent: 13 January 2003 14:57 >To: Ids (E-mail) >Subject: Altering fields > > >Hello all, > >This is what I want to do:- > >Create a new table within our dB, first field being integer (or char). >Input data into the table - about 50 rows. >Integer (or char) field will be populated NM1 sequentially to NM50. > >Then I want to alter the integer field to serial, so that the next item >entered will be NM51. > >Is this possible? > > > >Regards, >Malcolm Garbett >IT Manager > >"This e-mail and any files transmitted with it is confidential. If you >are >not the intended recipient, you should not use, copy or disclose its >contents, but should immediately notify the sender and delete the >e-mail. >The statements and opinions expressed here may not represent those of >the >company. Whilst we run anti-virus software on all e -mails we are not >liable for any loss or damage and the recipient is advised to run their >own >anti-virus software". >Newall Measurement Systems Ltd. > >DISCLAIMER >This message contains confidential information and is intended only for >the individual named. If you are not the named addressee you should not >disseminate, distribute or copy this e-mail. Please notify the sender >immediately by e-mail if you have received this e-mail by mistake and >delete this e-mail from your system. E-mail transmission cannot be >guaranteed to be secure or error-free as information could be >intercepted, corrupted, lost, destroyed, arrive late or incomplete, or >contain viruses. The sender therefore does not accept liability for any >errors or omissions in the contents of this message, which arise as a >result of e-mail transmission. If verification is required please >request a hard-copy version. _________________________________________________________________ MSN 8: advanced junk mail protection and 2 months FREE*. http://join.msn.com/?page=features/junkmail