RE: SQL SELECT with Similar Terms

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