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