After looking at it some more, I can't convert the entire table to use varchars for the particular fields due to page size. There are actually 3 formats for each text field (ex: Text, Html, RTf) so would easily be over 8000 total very often which would cause a page size problem.
I'm solved the problem for now. Basically I am selecting the query except for the text field. Then I loop over the query and select the text fields with SELECT TOP 1, append to arrays for and use them to add columns to the original query object. Exactly what I didn't want to do to start with but it isn't as bad as I thought. The number of unique text records are in the low single digits so results in on average two or three extra queries for this one request. This all boils down to bad database design to start with. This is one of the least normalized databases I've ever worked with--and at my company that's saying something. Thanks everyone for your help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
