Viewing SQL Binary Data

A simple post-it note to remember how to view binary data...

SELECT     CAST(CONVERT(varbinary(MAX), ColName) AS xml) AS ColName
FROM         dbo.TableName
WHERE     ([where clause])