RE: SQL SELECT with Similar Terms

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

Too much info, Vern. No A/C in that car?

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Friday, August 17, 2007 9:11 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL SELECT with Similar Terms

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