title: Show hexadecimal dump of string
body: <p>Is there any way to obtain an hexadecimal dump of a string in SQL Server? It'd be useful to troubleshoot character set and collation issues.</p>
  
  <p>In MySQL you'd do <code>SELECT HEX('€uro')</code> and in Oracle you'd do <code>SELECT DUMP('€uro') FROM DUAL</code>.</p>