Random String (Expression Function)

Purpose

The Random String function (RAND_STRING) generates a random lower case alpha-numeric string containing the number of characters specified. Most offten used to generate passwords, sync codes, etc. While the strings generated are random they are not guaranteed to be unique especially if the number of characters requested is small.

Parameters

The Random String function has one required parameter:

Length

Allowed Inputs: field value or positive number

Either use the use the Query Builder to choose a field that contains a positive number or use type a value to enter a positive number.

Output

The output of the Random String function returns a random alpha numeric string. The chances of two iterations of the Random String function generating the same string more than once is based on the number of characters returned for example RAND_STRING(1) has 36 possible returns so there is a 1 in 36 chance that the same string will be returned while RAND_STRING(8) has 2,821,109,907,456 possible returns.

Example

RAND_STRING(8) would result in a random string 8 characters long. Possibly “7h0e42hm”.

expression function - random string.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020