You may need quotes -- '%dcp.titleslug%' If it runs, I would expect it a LONG execution time
hth -brian On Tue, 22 Jul 2008 23:20:42 -0400, Michael Dinowitz wrote > 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:3105 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
