Hi All I would like to know if it is possible to use rand in an insert query. I have to create a table of about 500 users for a project allocating a individual password for each. I was thinking that putting a rand() in the relevant valuses area of my mysql insert statement would do it. Could you kind prople help with ideas or online examples. I have created a rand password maker as a standalone script but this dose not suit the requirements. I think the sql would be Insert into table set name=$name, password=rand(8,12); Right or wrong As always thank you for any help or guidance in advance. Dave C