Is it possible to generate an random integer number within a certain range?   eg. between 122 and 333?

There's one small problem with this code.  

Since the result is being converted to an integer, the fractions are always thrown away. The outcome is that the maximum number in the range will never be returned. I discovered this a couple years ago while writing a similar piece of code.

The fix is to add 0.5 before it's converted to an integer. This way, it will be able to produce results for the entire range.

var aa as double
var result as int

aa = Random(1.0)
result = ((333 - 122) * aa) + 122.5
writeln(result)
 

You can verify that entire range is possible, by running the following code in a mass update on a single record.

var result as int
var i as int

For i = 1 to 5000
	result = Random(333 - 122) + 122.5

	If result < 123 or result > 332
	writeln(result)
Next 

If you change "122.5" to "122", you will see that the slate will never display 333, only 122.