INSTR and string length problem
From: Ashley Morgan <amorgan_at_onet.co.uk>
Date: Mon, 14 Nov 2005 15:50:07 -0000
Message-ID: <4378b22e$0$63096$ed2e19e4_at_ptn-nntp-reader04.plus.net>
Hi,
Date: Mon, 14 Nov 2005 15:50:07 -0000
Message-ID: <4378b22e$0$63096$ed2e19e4_at_ptn-nntp-reader04.plus.net>
Hi,
I wonder if anybody can help. I have a where clause which looks for a string pattern e.g.
Select * from Table where Instr(String1,string2) > 0
Can somebody please explain why this is happening and how I can resolve it ?
Thanks in Advance. Received on Mon Nov 14 2005 - 16:50:07 CET