Re: SQL SELECT with Similar Terms

[Alan Shore <AlanShore@xxxxxxxx>]

Sorry Vern, that should have been
OOOhhh - nice one Vern



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 08/17/2007 09:41:03 AM:

> Michael
>
> Based on another recent post, here's a way to get what you want--
>
> select strip(translate(char20,' ', ':')), count(*)
> from mryan
> group by strip(translate(char20,' ', ':'))
>
> If you had more punctuations, just add them to the 3rd parameter of
> translate().
>
> HTH
> Vern
>
> At 08:18 AM 8/17/2007, you wrote:
>
> > Anyone know how to do this? I have data that looks like this:
> >
> > Rattan
> > Traditional
> > :Rattan:
> > Contemporary
> >
> > I'd like to produce a list like
> >
> > Rattan 2
> > Traditional 1
> > Contemporary 1
> >
> > The 'extra' search result with the colons around it should be the same
> > as the search result without the colons.
> >
> > Thanks...
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.