Best way to compare Binary and Int values

[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

[Nicholas Paldino [.NET/C# MVP]]

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?

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Sunit Joshi" <sj****@ingr.com> wrote in message
news:8f**************************@posting.google.c om...

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