Darn. That bites. Maybe a different searching mechanism if the simple query doesn't work.
Or a temp table. On Sat, Apr 23, 2011 at 5:45 PM, Jenny Gavin-Wear <jenn...@fasttrackonline.co.uk> wrote: > > I'm still on SQL 2000. > > Sadly it can't be done in SQL 2008 either: > > "The view cannot include text, ntext, or image columns, even if they are not > referenced in the CREATE INDEX statement." > > http://msdn.microsoft.com/en-us/library/ms191432.aspx ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:343934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm