<p>What's the most efficient way to convert the output of this function from a varbinary() to a a varchar()?</p>

[{'answer_id': 73503, 'author': 'Eric Z Beard', 'author_id': 1219, 'author_profile': 'https://Stackoverflow.com/users/1219', 'pm_score': 4, 'selected': True, 'text': '<p>How about this:</p>\n\n<pre><code>master.sys.fn_varbintohexstr(@binvalue)\n</code></pre>\n'}, {'answer_id': 887570, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 1, 'selected': False, 'text': '<p>CONVERT(varchar, @binary)</p>\n'}, {'answer_id': 7979858, 'author': 'Cheburek', 'author_id': 311108, 'author_profile': 'https://Stackoverflow.com/users/311108', 'pm_score': 2, 'selected': False, 'text': '<p>For SQL Server 2008 use</p>\n\n<pre><code>CONVERT(varchar, @binary, 1)\n</code></pre>\n\n<p>1 - style 0x060D,\n2 - 060D</p>\n\n<p><a href="http://msdn.microsoft.com/en-gb/library/ms187928.aspx" rel="nofollow">http://msdn.microsoft.com/en-gb/library/ms187928.aspx</a></p>\n'}]
['https://Stackoverflow.com/questions/73447', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/366182/']