>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/
If it's not broken, fix it until it is.
My Blog