Re: Simple SQL query help - String functions

Thorsten Kettner wrote:

> select translate(replace(replace(Lname,'Dr. ', ' '),' Jr.', '
> '),'ביא''" .', 'aea') ...

Assuming it doesn't contain "Dr" without the period, or "MD PhD" or M.D. Ph.D" and a near infinite supply of other variants. Often the job is hopeless unless the table is redesigned to guarantee integrity.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org