Depends on how you use the resulting string. If you're just eyeballing it, "randomly" select the first 6, 7, or 8 characters. If you're running in an EXEC, perhaps:
'PIPE ... | TAKE' random(6,8) '| ...' Mark Wheeler UnitedHealth Group > Date: Tue, 20 Jul 2010 09:35:47 -0500 > From: framaek...@ailife.com > Subject: Re: [CMS-PIPELINES] PIPE to generate random passwords > To: CMS-PIPELINES@VM.MARIST.EDU > > That looks great...no way to randomize 6 - 8 characters? > > _________________________________________________________________ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1