SELECT convert(VARCHAR(8000), a.Notes) as Notes
...

##</code><code>##

 convert(VARCHAR(1), a.Notes)