Create Random Data from a DB table

select a.FilePart1 + ' ' + b.FilePart2 + ' ' +  c.FilePart3 + '' + d.FilePartExr AS [FileName]

from (SELECT TOP 1 FilePart1 FROM  [YOUR TABLE HERE].[dbo].[HoneyPot_filename examples]

 ORDER BY NewID()) a,

 (SELECT TOP 1  FilePart2 FROM  [YOUR TABLE HERE].[dbo].[HoneyPot_filename examples] ORDER BY NewID()) b,

 (SELECT TOP 1  FilePart3 FROM  [YOUR TABLE HERE].[dbo].[HoneyPot_filename examples] ORDER BY NewID()) c,

 (SELECT TOP 1 [FilePartExr] FROM  [YOUR TABLE HERE].[dbo].[HoneyPot_filename examples] ORDER BY NewID()) d