Post reply

Why Hexidecimal

  • June 13, 2008 at 8:08 am

    #183437

    Hi all,

    Why would you use Hexidecimal in SQL ?

    Other than for fun?

    Thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • June 13, 2008 at 8:40 am

    #828554

    How would doing anything with hexidecimal be fun?

  • June 13, 2008 at 8:46 am

    #828559

    HEre are two examples of the fun side of it:

    SELECT REPLACE(0x5768617473206e6f742066756e2061626f75742074686973,'Check This','Out')

    print replace(0x2027202729,0x20,'print replace(0x2027202729,0x20,')

    😎

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

  • June 13, 2008 at 8:57 am

    #828579

    I would use it to store binary data.

  • June 13, 2008 at 8:58 am

    #828580

    You need to get yourself a hobby.

  • June 13, 2008 at 9:00 am

    #828585

    Thanks Michael E 🙂

    Most my mates same the same thing, I'm working on it 😀

    Michael J, please could you give me an example?

    thanks

    Chris

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life

Viewing 6 posts - 1 through 5 (of 5 total)

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