>Personally I would be surprised if either database had a way of handling >leading wildcards other than an exhaustive scan.
Use "Contains"/English Query. See MS-SQL Server Docs. Joe Eugene >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of [EMAIL PROTECTED] >Sent: Monday, April 05, 2004 12:24 AM >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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users