Home -> Usenet -> comp.databases.oracle -> Trimming Spaces

Trimming Spaces

From: Mark <marksmithy69_at_yahoo.com>
Date: 21 May 2002 11:54:56 -0700
Message-ID: <13e212f9.0205211054.7c44403e_at_posting.google.com> 






Hello.  I have an Oracle database table which contains a field with
people's names.  My problem is that there should only be unique names
in this field, but there are cases where the same name is there twice,
because there is an extra spaces between the first and last name.  For
example, there are cases where the name Eddie Vedder and Eddie  Vedder
appear in the table.  My job is to clean this up.  Is there a function
that I could use to do a mass clean-up to get rid of the space in the
middle?  Thank you.



Mark
Received on Tue May 21 2002 - 20:54:56 CEST












Original text of this message