Increasing Binary field length

Vote count:

0

I have a table with a populated column of type binary(24). I want to increase this field length to binary(32). This part's easy enough. The problem I'm running into is when I try to query the table based on that field's previous value. (We were using a hashbytes function).

So BEFORE the field length increase, I could just use: SELECT * FROM Table WHERE Field = HASHBYTES('md5', 'value')

AFTER the field length increase, this query returns nothing. How would I change the query to return the appropriate value? What can I add on to the end of the binary in order for it to be recognized?

Thanks!

asked 39 secs ago

Jeremy

98