Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: geting value from binary


    is it possible to get value as follows in SQL server

    I will have values in 101, 111 like in binary , I want to get its decimal values

    I want to get 5 for 101, 7 for 111 ....

    please let me know ...


  2. #2
    Join Date
    Aug 2003
    Delft, The Netherlands (EU)

    Re: geting value from binary

    So, you have a string containing a kind of binary number?

    Consider to solve this in a user-defined function. Loop through your string, and compute the power of 2 if applicable.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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