Hi all,

Just wondering if anyone had an idea on how to generate a random number between the range of 10,000 and 99,999 (Sql Server 2000). I think I can make use of Rand() but I don't think that this would be a different number everytime time it was called and not sure how to give it min of 10,000 and max of 99,999. I would assume that this is pretty common and so there must be something built in?

Any ideas?