Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: Converting Hexadecimal to Decimal or vice versa

    I'm in the process of converting two columns in two separate tables...

    One column in Table A has a hexadecimal number (with a nvarchar data type) i.e. "A5000000020" and converting it to a decimal it should be "11338713661472"...

    In Table B the column has a decimal number (with a bigint data type) i.e "1434519076864" and converting it to a hexadecimal the would make the value "9D500000005"

    I keep getting stuck, I can't seem to get either convert successfully!!!

    Please help !!!

    Thanks in advance!!!

  2. #2
    Join Date
    Apr 2008
    Iasi, Romania
    Provided Answers: 3
    Google on this:
    "sql server hexa to decimal convert function"
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

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