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

  • October 29, 2012 at 12:24 pm

    #1553856

    ChrisM@Work (10/29/2012)

    Jeff Moden (10/29/2012)

    Eugene Elutin (10/29/2012)

    Jeff Moden (10/27/2012)

    I wonder how many 3 and 4 letter swear words such a proccess will actually spell out...

    Actually it depends how you take it, at least some of them will be easy to remember :-D.

    By the way, English as a language is not very rich with such words in compare with some other languages (eg. world-champion in this business: Russian :hehe:)

    That's why we shouldn't be Russian to use incrementing Alpha-Numerics. 😛

    <<Groan>> Jeff that's awful!

    +1 for thats awful

    and even if we increase it to 5 alphanumeric we just increase the number of dirty words. of course if these are customer records who would not love the code 04SS as their customer number.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]