Results 1 to 2 of 2

Thread: identity column - alpha numeric

  1. 09-29-2005, 12:42 PM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    identity column - alpha numeric

    how do i create an identity column that automatically increments prefaced with a 'p'? eg, p1000, p1001, p1002, etc.
    Reply With Quote Reply With Quote
  2. 09-29-2005, 04:06 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Identity column works with integer only. For alpha numeric you have to maintain it yourself.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules