>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

Reply via email to