Re: HELP: SQL query using condition LIKE
From: Michael Downing <MDOWNING_at_ESTEC.BITNET>
Date: Thu, 4 Nov 1993 10:11:27 CET
Message-ID: <93308.101127MDOWNING_at_ESTEC.BITNET>
Date: Thu, 4 Nov 1993 10:11:27 CET
Message-ID: <93308.101127MDOWNING_at_ESTEC.BITNET>
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. Received on Thu Nov 04 1993 - 10:11:27 CET