I tries select dcp.title, cdb.title from gcd cross join cdb where cdb.titleslug like %dcp.titleslug%
This is on SQL 2000 and I got: error in where clause near '%' unable to parse query text. As for speed, we're talking about 80,000 titles to match between 7 databases on a dedicated CF enterprise home test box. It can run all night if it'll work. :) On Tue, Jul 22, 2008 at 11:04 PM, James Holmes <[EMAIL PROTECTED]> wrote: > "Something like where dcp.titleslug like %cdb.titleslug%" > > That's pretty much what I'd do in this situation (although it will run > slow) - is it not working? > > On Wed, Jul 23, 2008 at 10:04 AM, Michael Dinowitz wrote: > > I'm doing a join of two tables where each has a title-slug (a string with > > all non-alphanumeric characters converted and dashes between words). I'd > > like to do a like join between the two title slugs but don't know how to > do > > it with non-variable data. Something like > > where dcp.titleslug like %cdb.titleslug% > > > > the dcp titleslug will be somewhere in the cdb.titleslug > > > > any ideas? > > -- > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3102 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
