472,126 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

Best way to compare Binary and Int values

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
Nov 16 '05 #1
1 1774
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

Nov 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Davy | last post: by
reply views Thread by Michael Jenck | last post: by
50 posts views Thread by titan nyquist | last post: by
10 posts views Thread by agendum97 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.