Simple SQL query help - String functions

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 Received on Tue Apr 24 2007 - 14:34:35 CDT