Had a need to generate a partially random string in a SQL proc today. Came up with the following that is pretty short and sweet:
CAST(CAST(newid() as varchar(40)) as varchar(8))
Idea was originally inspired from this link:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59194