Home Forums SQL Server 2014 Development - SQL Server 2014 Trying to use the HASHBYTES of a nvarcar(Max) RE: Trying to use the HASHBYTES of a nvarcar(Max)

  • July 29, 2016 at 4:57 pm

    #1892732

    1) Try CASTing it as the data type you want.

    2) What do you get when you do DATALENGTH(..) on your calculation?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service