Update and Rand() Doesn't work?

[Ruslan Zasukhin]

On 6/13/09 9:06 AM, "Antuan Johnson" <amjohnson09 at gmail.com> wrote:

Hi Antuan,

> Is there a reason the update query doesn't work with the random function? Just
> wondering if this is a bug or not, because I'm not quite sure of the purpose
> of the Rand() function if it can't update as well. It works technically but it
> always returns the same value - that's not random.
> 
> Update TableA Set FieldA=  RAND()

What about 

    SELECT RAND()

?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]