id guess "midget donkey" On Tue, Jun 23, 2009 at 1:07 PM, Jacob<[email protected]> wrote: > > That makes two of us... > > -----Original Message----- > > > > My head hurts. :) > > Jacob wrote: >> ... or two. Have to be kidding me! >> >> >> Search term: 90 all naturals >> >> The query: >> >> Select Top 1000 * From >> >> DVD >> >> >> Where ( Stock = '90 all naturals' >> OR ( >> Subtitle like '%90 all naturals%' >> >> OR REPLACE(Subtitle, '''', '') like '%90 all >> naturals%' >> or Subtitle like '%90 all naturals!%' >> OR REPLACE(Subtitle, '''', '') like '%90 all >> naturals!%' or Subtitle like '%90_all_naturals%' >> OR REPLACE(Subtitle, '''', '') like >> '%90_all_naturals%' or Subtitle like '%90_all_naturals%' >> OR REPLACE(Subtitle, '''', '') like >> '%90_all_naturals%' or Subtitle like '%90 all naturals!%' or Subtitle like >> '%90 all%' >> ) >> OR Title like '%90 all naturals%' >> OR REPLACE(Title, '''', '') like '%90 all naturals%' >> >> or Title like '%90 all naturals!%' >> OR REPLACE(Title, '''', '') like '%90 all >> naturals!%' or Title like '%90_all_naturals%' >> OR REPLACE(Title, '''', '') like '%90_all_naturals%' >> or Title like '%90_all_naturals%' >> OR REPLACE(Title, '''', '') like '%90_all_naturals%' >> or Title like '%90 all naturals!%' or Title like '%90 all%' >> or Title like '%90: all naturals %' >> >> or Title like '%90? all naturals %' >> >> or Title like '%90! all naturals %' >> >> or Title like '%90 all: naturals %' >> >> or Title like '%90 all? naturals %' >> >> or Title like '%90 all! naturals %' >> >> or Title like '%90 all naturals: %' >> >> or Title like '%90 all naturals? %' >> >> or Title like '%90 all naturals! %' >> OR Title like '%90%' >> OR Title like '%90 all%' >> OR Title like '%90 all naturals!%' >> >> ) >> AND url like '%.%' >> order by Rating DESC, Title >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:298832 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
