• You can convert hashbytes to varchar through XQuery as well.

    Here is the solution. http://raresql.com/2013/04/02/sql-server-how-to-convert-hashbytes-to-varchar/

    MI
    http://raresql.com