Re: SQL SELECT with Similar Terms

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...
> >--