here is a function i use on an asp page

it would be called by using something like this:

sRegNum = RandomPW(8)

 Function RandomPW(myLength)

  'These constant are the minimum and maximum length for random

  'length...

Here is another way to do it. It mimics the InitCap function in Oracle

CREATE  function dbo.fn_InitCap

(

    @inString varchar(4000)

)

returns varchar(4000)

as

BEGIN

    /******************************************************************

    INITCAP returns char, with the first letter of each word...