I am trying to create a function in SQL Server that will return a random password (composed of random characters), of a specified length. Transact-SQL seems to have a problem with including non-deterministic functions - such as rand() or getdate() - within a user defined function.

Does anyone know a work around?

CREATE FUNCTION dbo.ufn_CreatePassword ( @pwlength integer)
RETURNS varchar(255)
AS .....

Thank you,




Rand

__________________
Rand

See this solution http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44757