Re: How to search a text field of Varchar2 (2000)

From: Milan Smederevac <no_garbage.Smeky_at_eunet.yu>
Date: Sat, 14 Apr 2001 02:27:53 +0200
Message-ID: <9b85cj$s30$1_at_news.EUnet.yu>


> 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]
Hello,
You may try to use UPPER function, somthing like this:

SELECT mch_code, mch_name
FROM equipment_all_object
WHERE UPPER(note) like '%ORDER% &Order_no';

But, there is problem, in this way you will get full table scan on your table and that may be lengthy depending on size of table. Received on Sat Apr 14 2001 - 02:27:53 CEST

Original text of this message