That's true. There's a slight chance of duplicate checksums. Another technique that I've used is HASHBYTES similar to this:

select HASHBYTES('md5',NAME + isnull(Color,'Unkown')), * FROM Production.Product

It takes longer to run but it produces very unique values like 0x313FB214C93591081E720123253B1398.