Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple SQL query help - String functions

Re: Simple SQL query help - String functions

From: <sybrandb_at_hccnet.nl>
Date: Tue, 24 Apr 2007 23:27:10 +0200
Message-ID: <pets23p58e9himchkjgne8vsq3eg9hd1jh@4ax.com>


On 24 Apr 2007 12:34:35 -0700, Tangz <thangam.moor_at_gmail.com> wrote:

>I need a select query that selects the first, last and middle name of
>employees without hyphens, apostrophes, blanks, periods, suffixes
>(Jr.) or prefix (Dr.).

'Parsing' strings will never ever undo the ramifications of bad database design.
The number of prefixes you'll need to deal with is endless. Fix your tables instead of fighting symptoms.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Apr 24 2007 - 16:27:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US