Checksum

Table of Contents


Overview
The checksum function generates a checksum value based on the data within documents of a specified schema. It's utilized alongside the SELECT statement to produce a checksum value that represents the content of the documents within the schema, aiding in data integrity validation and comparison.

Prototype
Numeric Checksum(String text)

Example
round-pushpin Selects documents from the Word schema and calculates the checksum of the text field.
SELECT
    Text,
    Checksum(Text) as CRC
FROM
    WordList:Word
WHERE
    Text LIKE 'Cat%'

See also

Related