Unlike MySQL, Filemaker's internal SQL implementation doesn't feature the MD5(° function, that creates a hash from a string.
That's a big miss because being able to compute a MD5 hash on a bunch of columns can yield dramatically faster imports / updates by comparing the hashes, and just update the records whose hashes are different.
So instead of updating 100K records, you can easily find out the 10 that really need to be updated.
So I wish we could be able to write such a query
SELECT Key,MD5(value1+value2+value) FROM myTable
That would result in something like that