I have a table that has a password field. There are hundreds of entries that currently do not have a password. I want to randomly generate passwords for the fields. I have written a stored procedure named "random_string_generator" that will randomly generate an 8-character string of text in a field named "tmp". How can I insert these strings of text into the password fields, where each field is randomly selected? I&#039;ve tried several ways, including the following, and nothing seems to work.<BR><BR><BR>CREATE PROCEDURE dbo.random_password_generator<BR>AS<BR> UPDATE table_name<BR> SET pwd = tmp<BR> FROM dbo.random_string_generator<BR> WHERE pwd IS NULL<BR>GO<BR><BR>Any ideas?