Converting 32 bit hex to floating point

• sygerb77

  SSC-Addicted

  Points: 414

  More actions

  August 22, 2009 at 9:17 pm

  #156138

  I'm writing a stored procedure to read and interpret values stored in a binary file. I've reached a segment of the file where float values are represented by 4 bytes (as opposed to integers represented by 2 bytes) and I'm totally STUCK. Does anyone know how to convert 4 bytes to a floating point using T-SQL?

  For example, I am reading the following bytes from a binary file: 00 00 FA 43, and I know the end result should be 500. Anyone know how to do this?

  THANKS SO MUCH

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  August 25, 2009 at 12:08 pm

  #1044403

  and just what is the format of the 4 bytes shown ?

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."