Whilst not a 'built in' facility, you can code a solution around this to get (more or less) instant results using a dual/degenerate inversion scheme - of course that would also have required you to know in advance that you wanted to perform such a wildcard search on the field in question.
Ross Ferris Stamina Software Visage – an Evolution in Software Development >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of [EMAIL PROTECTED] >Sent: Monday, 5 April 2004 2:24 PM >To: [EMAIL PROTECTED] >Subject: Re: Modern Universe (TESTING) > >In a message dated 4/4/2004 9:11:10 PM Pacific Daylight Time, >[EMAIL PROTECTED] writes: > > >> >One thing I think everyone's missed (deliberately or otherwise) >> >wildcard (WHERE address LIKE '%EXPLORATION'). >> >> I brought this up a couple of times, nobody seemed to be interested >> to check the difference. >> >> Joe Eugene >> > >Personally I would be surprised if either database had a way of handling >leading wildcards other than an exhaustive scan. >Will >-- >u2-users mailing list >[EMAIL PROTECTED] >http://www.oliver.com/mailman/listinfo/u2-users > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.648 / Virus Database: 415 - Release Date: 31/03/2004 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 31/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
