i want to know how sql compare the two BINARY(NOT VARBINARY) data

because i found if first BINARY DATE is for example

first 0x 85 86 87 88 00 86 99 ..... (input parameter)
second 0x 85 86 87 88 00 89 54 ..... (store in database)

now you can see the first and second are not same

but when i run the store procedure

for example ........ where first = second
the SQL SEVER 2000 think the first = second, why

how can make the sql server compare the BINARY data exactly?


thanks a lot :?
Posted on 2005-02-10 20:32:33 by jndk