Best way to compare Binary and Int values

  • Thread starter Thread starter Sunit Joshi
  • Start date Start date
S

Sunit Joshi

Hello
I have a situation like this, I have 2 colns in an SQLServer table
which are set to following SQLServer data types
sTime->Binary (length=8), and tTime -> Int (length=4)

I need to compare the 2 values and was looking for the best way to do
this. Any hints are greatly appreciated.


thanks
Sunit
 
Sunit,

What is the algorithm for comparison here? Given that the sTime value
has 8 more bytes in it (resulting in a vastly larger value set than the
integer with four bytes), you are going to have values in the 8 byte space
that can't be represented in the 4 byte space.

What are you trying to do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to compare Binary and Int values 1
HowTo Compare Binary and int colns 3
Integer conversion to Binary Coded Decimal 6
a question about binary serialization 3
SQLBinary to compare to Int 5
Fast byte array compare for ordering purposes 5
Convert UInt16 to binary 5
Best way to read/write binary data 4

Back
Top