We use the rand() function in our application login routine against a 6.5
database, in testing our migration to 7.0, we have found out the random
function in 7.0 does not behave exactly the same as in 6.5, trying the
following query from iSql against both a 6.5 database and a 7.0 database
returns different values - this behaviour "breaks" our application. Does
anyone else have any expierence using the random function?? Could you
provide some insight??
BEGIN
SET NOCOUNT ON
SET NOCOUNT OFF
END
Tom Boyce
Enterprise Project Manager
National Institutes of Health, Center for Information Technology
301-594-2666