>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 >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of Ray Wurlod >Sent: Sunday, April 04, 2004 1:27 AM >To: U2 Users Discussion List >Subject: RE: Modern Universe (TESTING) > > >One thing I think everyone's missed (deliberately or otherwise) >was that Sara's original post had a constraint with a LEADING >wildcard (WHERE address LIKE '%EXPLORATION'). >The argument that has been raging since has used examples with >TRAILING wildcards (WHERE name LIKE 'Sara%'). > >Apples and oranges, folks, especially if B-tree indexes are involved. >-- >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