Yep. You can actually store a DTD in the SQL database that will validate any XML inserted into it if you wish. I believe you can also build very fast indices over an XML field, where a text field w/ full text index may not be as zippy.
Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -----Original Message----- From: Chad Gray Sent: Thursday, June 28, 2007 2:52 PM To: CF-Talk Subject: MS SQL XML Datatype So is there any advantage or reason I should be storing XML data in a XML field vs. varchar?? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4