Re: SQL SELECT with Similar Terms

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

LOL Alan - not bad for a brain on vacation! And soon driving topless 
on his way to northern Illinois! As I hinted to Charles - this list is awesome!

At 09:04 AM 8/17/2007, you wrote:

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