you could do this with an ALTER TABLE SQL command, however it will fail if the contents of your text or ntext fields exceeds the capacity of varchar(max)
On Fri, Jul 30, 2010 at 7:19 AM, Pete Ruckelshaus <pruckelsh...@gmail.com> wrote: > Unfortunately, as updates to system tables are not allowed (and are > generally a bad idea), there's no quick and easy way to convert text or > ntext columns to varchar ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335897 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm