JediHomer wrote: > my initial thoughts are that b.comment is a field of type ntext or text. > > This afaik cannot be LIKE compared against, you need to enable and use > free text searching instead
Actually, that's perfectly acceptable. See the error: "cannot be compared or sorted, except when using IS NULL or LIKE operator." The problem appears to actually be that I'm including it in the GROUP BY clause... This experts exchange message supposedly has my answer.. I've avoided registering there but I guess maybe I should for this one. http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21263502.html - Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
