Convert Name field from Upper Case to Proper Case

From: Jeff R (jdrut10_at_hotmail.com)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 14:11:09 -0700

I have a database where the last name is in all upper
case. I need to pass through the database one time and
convert the last name field to proper case.

Any suggestions on how to do this?

Thanks

Jeff...

Relevant Pages

  • Re: Correct casing User last name retireved from database
    ... to always upper case, and then always compare against the new column. ... On your> database table store the names in their proper case and have another field> for the uppercase values, put a trigger on the table to update the other ... But, for names like O'Rieley, McDonald, propercasing the>>> name ...
    (microsoft.public.dotnet.languages.csharp)
  • case sensitive string comparison
    ... in our address database we have stored thousands of records which have ... entries written in upper case. ... proper() to correct them, BUT I do NOT want to touch the remaining ...
    (microsoft.public.fox.programmer.exchange)
  • Re: how to make all Updates Inserts in the database Upper case?
    ... of the database table, stored procs and application, it would take me a long ... when i set would force all the data comming in to Upper case. ... > converts all the input data to upper case, and then passes to the database. ... > I have a Sql server 2000 database which is already in production. ...
    (microsoft.public.sqlserver.server)
  • Re: Validating: If the value EXISTS in Db then show error!
    ... I dont think the it is case sensitive coz when I entered the Upper case ... the Validation sumaary doesnt show error message. ... >> custom validator to check that if the value already exists in the database, ... > Hans Kesting ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Indexing A Function???
    ... i would like to see names in a database ... to be Upper for te first char and lower for the rest; ... therefor i would use a func index ...
    (comp.databases.informix)