I would like to populate a password field in a table with a randomly generated password. I have a sp that generates the password, but cannot figure out how to use it in an INSERT statement. I tried to create a UDF but cannot use RAND() in it.

TIA

John