>>>>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.
>
>In this case RAND() function should work just fine to generate a single random number.

Thank you.