"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:3101 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
