No I DO NOT WANT TO HASH ONLY THE FIRST 50 CHARACTERS. I WANT TO HASH THE ENTIRE FILE BUT HAVE THE RESULTANT FIELD NVARCHAR(50) OR CHAR(50) INSTEAD OF...

You said "Quick questions, on what do you base that assumption?" I can't directly answer your question because YOUR QUESTION is wrong. IT'S NOT AN ASSUMPTION BUT AN OBSERVATION....

You said "I'm not to keen on a calculated column for the hashes, performance being an obvious one" the theoretical performance hit is extremely negligible to the point of being...

You said "The length of the output has nothing to do with the input lenght" but that seems to be what is happening. How else do you explain the...