Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple SQL query help - String functions
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 DBAReceived on Tue Apr 24 2007 - 16:27:10 CDT