http://sqlblogcasts.com/blogs/tomaztsql/archive/tags/for+xml+path/default.aspxTags: for xml pathenCommunityServer 2007.1 (Build: 20917.1142)http://sqlblogcasts.com/blogs/tomaztsql/archive/2012/01/01/simple-word-randomization-based-on-dictionary.aspxSun, 01 Jan 2012 16:00:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:16047Tomaz.tsql0http://sqlblogcasts.com/blogs/tomaztsql/rsscomments.aspx?PostID=16047http://sqlblogcasts.com/blogs/tomaztsql/archive/2012/01/01/simple-word-randomization-based-on-dictionary.aspx#commentsBased on list of words, one can randomize the letters in the word using simple cross apply. ;with dictionary as ( select &#39;soundgarden&#39; as word union all select &#39;impossible&#39; as word union all select &#39;apple&#39; as word union all select...(<a href="http://sqlblogcasts.com/blogs/tomaztsql/archive/2012/01/01/simple-word-randomization-based-on-dictionary.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=16047" width="1" height="1">withfor xml pathcross apply