Re: HELP: SQL query using condition LIKE
From: Thomas Dwyer III <tomiii_at_mtu.edu>
Date: 24 Nov 1993 09:37:26 -0500
Message-ID: <2cvrj6$c46_at_bambam.cts.mtu.edu>
Date: 24 Nov 1993 09:37:26 -0500
Message-ID: <2cvrj6$c46_at_bambam.cts.mtu.edu>
Michael Downing (MDOWNING_at_ESTEC.BITNET) wrote:
>Try where instr(field1,field2) <> 0
>
>It does the same as a LIKE but a lot faster.
>
>N.B. Dont use % characters in your field for pattern matching.
This is not the first time I've seen this suggestion. Would someone care to explain under what conditions this is true and why?
Thanks,
Tom.III
tomiii_at_mtu.edu
Received on Wed Nov 24 1993 - 15:37:26 CET