Re: LIKE

From: Alan <alan_at_erols.com>
Date: Wed, 8 Oct 2003 14:54:38 -0400
Message-ID: <bm1mh9$hpdor$1@ID-114862.news.uni-berlin.de>

"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:lve8ov4r26nl9203le98dqaikh9eslcfrf_at_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

This is also where his instructor would probably like him to look. Received on Wed Oct 08 2003 - 13:54:38 CDT