Hi All Both the ib_udf rand() and Firebird internal rand() have a description of "Returns a random number between 0 and 1". I'd expect it's exclusive on both ends (i.e. the number can never be 0 or 1), but the documentation is not absolutely clear on this, especially considering that in SQL BETWEEN...AND means inclusive. Can anyone confirm whether it's inclusive or exclusive?
Thanks Huan
