Oh I get the problem now (my bad). This works in Oracle:
select dcp.title, cdb.title from gcd cross join cdb where cdb.titleslug like '%'||dcp.titleslug||'%' || is the string concatenation operator in Oracle; try the appropriate one for your DB. On Wed, Jul 23, 2008 at 11:20 AM, Michael Dinowitz <[EMAIL PROTECTED]> 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:3103 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
