• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • FLOOR()
  • FORMAT()
  • HEX()
  • OCT()
  • RAND()
  • ROUND()
  • UNHEX()

RAND()

Return a random decimal number between 0 and 1.

Prototype

decimal RAND()

Example

Select a random number between 50 and 150.

SELECT OID, Date, ROUND(RAND()*100)+50 AS RandomNum FROM Invoice

Return

Random decimal number between 0 and 1.

• < OCT()
• ROUND() >