Is there a way to calculate a unique hash value based on the combination of
4 column values (two Nvarchar and two Int)?
I attempted to calculate a hash in T-SQL for the combination of 4 columns by
concatenating the 4 column values in a string and then calculating the
CHECKSUM on the string but CHECKSUM ignores some characters (The apostrophe
' and the dash "-"). There are other problems with content and order of the
columns when values are null or null strings.
Any help would be greatly appreciated.