Re: query

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Jan 2002 17:08:45 +0100
Message-ID: <o9c05u8poq6967mdr69iahritiaqgmu7vt@4ax.com>

On Thu, 24 Jan 2002 12:20:07 GMT, "IvanCleo" <ivansiviero_at_hotmail.com> wrote:

>hi evryone.
>I know this is a simple question for you.
>
>I have an oracle table named TABLE which defines a column named COLUMN.
>The column type is String and it contains values like the following ones:
>
>"the value of the column is this"
>"the value of the column is that"
>"the value does not exist"
>
>i'd like to launch a SELECT statement to get only columns which contain the
>word 'column'.
>Any suggestion ?
>Thanx.
>Ivan
>

sql reference manual, keyword 'LIKE'

Please have us spend our spare free time for more challenging questions, other than a deluge of RTFM ones.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 24 2002 - 10:08:45 CST