Hi
I posted this question on another thread in the Links SQL Discussion but it is probably more relevant to this Forum.
Alex posted the following and it works for others but not me.
UPDATE Users SET Password = FLOOR(RAND() * 10000)
All I get is the same 4 digit number on every record.
I'm on a MS SQL Server, could this be the problem.?
Regards
minesite
I posted this question on another thread in the Links SQL Discussion but it is probably more relevant to this Forum.
Alex posted the following and it works for others but not me.
UPDATE Users SET Password = FLOOR(RAND() * 10000)
All I get is the same 4 digit number on every record.
I'm on a MS SQL Server, could this be the problem.?
Regards
minesite