Convert Name field from Upper Case to Proper Case
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?
- 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 ...
- 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 ...
- 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. ...
- 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 ...
- 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 ...