RE: SQL SELECT with Similar Terms

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Yeah, it IS nice - give credit to this list - someone mentioned the 
translate() function earlier this week.

At 08:54 AM 8/17/2007, you wrote:

> Oh I like that Vern...
>
> Charles
>
>
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
> > Sent: Friday, August 17, 2007 9:41 AM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: SQL SELECT with Similar Terms
> >
> > 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.
> >
> >
> >
>
> This e-mail transmission contains information that is intended to be 
> confidential and privileged.  If you receive this e-mail and you are 
> not a named addressee you are hereby notified that you are not 
> authorized to read, print, retain, copy or disseminate this 
> communication without the consent of the sender and that doing so is 
> prohibited and may be unlawful.  Please reply to the message 
> immediately by informing the sender that the message was 
> misdirected.  After replying, please delete and otherwise erase it 
> and any attachments from your computer system.  Your assistance in 
> correcting this error is appreciated.
>
> --
> 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.