Re: LIKE

From: Anil G <anil.gundugollu_at_comsys.com>
Date: 8 Oct 2003 15:42:16 -0700
Message-ID: <3d5549c5.0310081442.774a9560@posting.google.com>

select * from tabname
where instr(replace(colx,' ',''),'A,') > 0

should do the job

"Roger Smith" <rsmith22_at_fastmail.net> wrote in message news:<KGWgb.11908$Sg4.11682_at_edtnps84>...
> 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
Received on Wed Oct 08 2003 - 17:42:16 CDT