How to search a text field of Varchar2 (2000)
From: Andy <andy.konopka_at_camtronics.com>
Date: Fri, 13 Apr 2001 15:09:33 -0500
Message-ID: <p1JB6.269$A07.100413_at_homer.alpha.net>
Date: Fri, 13 Apr 2001 15:09:33 -0500
Message-ID: <p1JB6.269$A07.100413_at_homer.alpha.net>
Hello,
[Quoted] I was wondering if someone has had to search notes fields of up to 2000 characters
I am trying to use a general search on an order number but the problem I
have is that
it is formatted differently in each note and I cannot repeatedly find it
here is my sql:
select mch_code, mch_name from equipment_all_object where note like
'%ORDER% &Order_no'
it is listed in the database as
Order No S15011
or as
[PRCONFIG CUST ORDER: 804084]
Appreciate any suggestions
Received on Fri Apr 13 2001 - 22:09:33 CEST