• In my case the result is consistent, I used this script:

    declare @Paper varchar(100), @Value_date datetime2;

    declare @result VARBINARY(40);

    select @Paper = 'Kotimaiset osakaslainat, kiint.', @Value_date = '2017-11-30';

    declare @tst table(result VARBINARY(40));

    create table dbo.tst(result VARBINARY(40));

    select CAST(HASHBYTES('MD5', CAST(@Value_date AS char(10)) + ' # ' + LTrim(Rtrim(@Paper))) AS VARBINARY(40)) dv_key;

    set @result = HASHBYTES('MD5', CAST(@Value_date AS char(10)) + ' # ' + LTrim(Rtrim(@Paper)));

    select @result;

    insert into @tst values(HASHBYTES('MD5', CAST(@Value_date AS char(10)) + ' # ' + LTrim(Rtrim(@Paper))));

    select * from @tst;

    insert into dbo.tst values(HASHBYTES('MD5', CAST(@Value_date AS char(10)) + ' # ' + LTrim(Rtrim(@Paper))));

    select * from dbo.tst;

    drop table dbo.tst;