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