• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • COS()
  • DEGREES()
  • EXP()
  • FLOOR()
  • FORMAT()
  • HEX()
  • LN()
  • LOG()
  • OCT()
  • PI()
  • POW()
  • RADIANS()
  • RAND()
  • ROUND()
  • SIN()
  • TAN()
  • UNHEX()
  • MD5()

MD5()

Returns a 128-bit checksum as a 32-character hexadecimal string.

Prototype

string MD5(int str)

Parameter

• str - String to produce a checksum for.

Return

The hexadecimal string representation of the 128-bit checksum value of a string.  If NULL is passed in, NULL is returned.

Example

SELECT MD5(Data) AS Checksum FROM File

Related

HEX(), UNHEX()

• < #META