Retrieving data stored as image as string in SQL Server 2005 -

i need retrieve xml file stored image data in sql server.

i using query -

select      convert(varchar, convert(binary, zd.validcontent))       zonedata zd join      contentitem ci on zd.itemid = ci.itemid      id = @dpathid  

i text but result returns small portion of xml file -

<?xml version="1.0" encoding=" 

please help. thanks.

char , varchar:

char [ ( n ) ]

varchar [ ( n | max ) ]

when n not specified in data definition or variable declaration statement, default length 1. when n not specified when using cast , convert functions, default length 30.

so, please specify suitable length (e.g. max shown in @devart's answer, or more appropriate value)