Post reply

The answer to life, the universe and prime numbers

  • February 27, 2015 at 12:57 am

    #1780486

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 27, 2015 at 2:03 am

    #1780499

    patricklambin (2/26/2015)

    Excellent post , Toreador. You are right. The * means only that the value -51 cannot represent any ASCII character for which the minimum value is 0.

    Actually that's not what I said, and it's not true. The * means that "-51" is too long to fit into a varchar(1) field.

    If you try ASCII("-51") you will get 45, which is the ascii value for "-" - the rest of the string is ignored.

  • June 9, 2015 at 12:29 am

    #1803874

    Hahahaha yes 42 is the answer to everything

Viewing 3 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply