Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    May 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Micorsoft SQL Server 2005

    hi there!

    I need help on how to create alphanumeric autonumber in SQL... like for example: HP1, HP2, HP3

    is there other way aside from creating it in codes?

    thanks!!!
    Last edited by Lis716; 06-18-2007 at 06:28 AM.

  • #2
    New Coder
    Join Date
    May 2007
    Location
    SF, CA
    Posts
    55
    Thanks
    0
    Thanked 4 Times in 4 Posts
    Well you can either use concat with a string literal or two seperate columns.

    so something like

    select concat('HP', ID) from table

    semper fi...


  •  

    Posting Permissions

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