Re: Searching strings
From: Raju Lokhande <rajul_at_netaxis.com>
Date: 25 Mar 1995 11:20:36 -0500
Message-ID: <3l1fsk$n6n_at_eliza.netaxis.com>
Date: 25 Mar 1995 11:20:36 -0500
Message-ID: <3l1fsk$n6n_at_eliza.netaxis.com>
John Jones (john_at_iluvatar.tip.duke.edu) wrote:
: I need to search a field that has been defined as varchar2(2000) for any
: occurence of the word 'LITIGATION' does anybody know of an easy way to
: this. Any help or pointers will be appreciated.
: --------------------------------------------------------------------
: John Jones | my views are my own.........
: Oracle Consultant | no matter what company they are
: john_at_iluvatar.tip.duke.edu | coming from.
: --------------------------------------------------------------------
Try the following WHERE clause
where field_name like '%LITIGATION%'
Raju Lokhande
rajul_at_netaxis.com
Received on Sat Mar 25 1995 - 17:20:36 CET