How to generate a random number for a column

Database
Enthusiast

How to generate a random number for a column

Hi all,

I have created a new decimal field for one of my tables. Is there a function to populate this field with a random figure other than inserting a sequential figure for it?

Thanks.
2 REPLIES
Enthusiast

Re: How to generate a random number for a column

Hi,

Try with RANDOM function...
Syntax: RANDOM(lower_limit, upper_limit)

Regards,
Balamurugan
Enthusiast

Re: How to generate a random number for a column

Thanks, it works