• HASHBYTES is meant for a literal string (or binary) import of one column, so any potentially null fields would need to be wrapped in ISNULL(x,'') - and that's assuming you want a NULL string to be treated the exact same as an empty string.

    CHECKSUM and BINARY_CHECKSUM have multi-column input, as opposed to a single string value.