Re: LIKE

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Wed, 08 Oct 2003 18:32:33 +0200
Message-ID: <lve8ov4r26nl9203le98dqaikh9eslcfrf@4ax.com>

On Wed, 08 Oct 2003 16:11:22 GMT, "Roger Smith" <rsmith22_at_fastmail.net> wrote:

>Hi,
>
>I want to query a comma delimted field in a table that has theses values:
>
>A, B
>A
>AB, C
>A, C
>C
>
>
>if I do...where comma_field like ('%A%') it will return row 3 (I only want
>the rows that contain A). I don't want to search for A, or A[blank]. Is
>there some other way like field length = 1?
>
>Roger
>

Sure there is. All available functions are documented in the sql reference manual online at http:/tahiti.oracle.com

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Oct 08 2003 - 11:32:33 CDT