Re: Simple SQL query help - String functions

Tangz 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.). My current query looks something like this:
>
> Select Fname, Lname, Mname
> from employee
> where <condition>
>
> Any help will be appreciated !
>
> Thanks
> Thangam

It is impossible to help you based on what you have asked. Where would one find the hyphens, apostrophes, blanks, periods, suffixes, prefixes, etc.?

Give us three to five sample rows and the desired outcome.

Explain what is wrong with your current statement.

And include your version to 3 decimal places.

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