>>Hi,
>>
>>In VFP I am creating a random number (that has to fit into N(8,0) size field) as following:
>>
>>
>>rand(-1)
>>nNumber = int( rand() * 100000000 )
>>
>>
>>I found online article that has the following code for creating a random number:
>>
>>
>>SELECT CAST(RAND() * 1000000 AS INT) AS [RandomNumber]
>>
>>
>>Is this equivalent to the VFP code?
>
>Sort of. Do you want to create a random number for every row or a single value? RAND() function will return the same value for all rows in the result, so you need to use checksum(NewID()) in order to generate random value for every row.
>
>Check this article by Pinal Dave
>
http://blog.sqlauthority.com/2007/04/29/sql-server-random-number-generator-script-sql-query/I want/need to create just one random number for the current row, when Inserting a record. This is not a PK field but still, for business purpose, needs to have a unique entry. So I don't think that I would need to use checksum().
And I will see the article by Pinal Dave; I read a lot of his on-line articles; he is very prolific.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham