Re: [SQL] Creating sequences

2000-08-21 Thread Adam Lang
u can set the initial value to alphanumeric and it will increment from there. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Gannon, Terry" <[EMAIL PROTECTED]> To: "'Adam Lang'" <[EMAIL PROTECTED]> Sent: Friday

[SQL] Creating sequences

2000-08-18 Thread Adam Lang
Is it possible to have a sequence (or something like it) when it increments alpha-numeric? Say the first value is set at A01 and it will increment to A02, A03 by default. Also, it would be good if it could be made the primary key. Adam Lang Systems Engineer Rutgers Casualty Insurance Company