Just to be more complete: http://databases.aspfaq.com/general/why-is-query-analyzer-only-returning-255-characters.html Also, Brian... You know that MS SQL has a row limit of 8060 bytes per row?? If you really need that size of a varchar column you should look at the Text column type. -----Original message----- From: Brian Cummiskey brian at hondaswap.com Date: Mon, 05 Mar 2007 06:41:16 -0800 To: "thelist at lists.evolt.org" thelist at lists.evolt.org Subject: Re: [thelist] query getting truncated > Brian Cummiskey wrote: > > Hi guys- > > > > Have an odd problem here. > scratch this post. figured it out. Turns out there's an option for it :P > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! >