She's already using ntext. She is trying to figure a way to search two different ntext fields in two different related tables returned by the same query using FREETEXTTABLE
On Sat, Apr 23, 2011 at 7:28 PM, Russ Michaels <[email protected]> wrote: > > If you are using SQL Server 2000, to avoid truncation you can use TEXT or > nText fields instead. These are BLOBS and are not contained by the max row > length. The combined max row size for all other fields is 8060, anything > above this will be truncated. > Since SQL Server 2005 these were depreciated in favour of the new > VarChar(max) data type. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
