Home Forums SQL Server 2008 T-SQL (SS2K8) Alphanumeric number generation RE: Alphanumeric number generation

  • October 8, 2012 at 7:17 am

    #1546708

    Cadavre (10/8/2012)

    Skanda (10/8/2012)

    Thank U Boss,

    It is looking great...

    but i need every record should have a numeric and alpabet,

    in present code, some records are only alphabetic....

    In your original post, you said: -

    Skanda (10/8/2012)

    0001, 0002, ... , 0009, 000A, ... , 000Z, ... , 0010, 0011, ... , 001A, ... and so on till... , ZZZZ

    "ZZZZ" doesn't have numeric values.

    And "0001, 0002, ... , 0009..." have no alpha characters...

    I guess the method I've offered in the following thread might help you:

    http://www.sqlservercentral.com/Forums/Topic1267659-391-1.aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]