Home
Ask
Answer
Groups
Debates
Login
Search
»
Categories
»
Programming
»
SQL & Databases
This Question Is Answered:
How Can The Values In A Database Table Be Changed To Proper Case?
The values in the name column of the students table are in upper case (eg JOHN). I wan to change them to (John).
fiend
14 Feb 2008 08:46
Flag
You can use the initcap SQL function. Your query would be in the form
UPDATE STUDENTS SET NAME = INITCAP(NAME)
This would change the values in the name column in the format you require.
Unrated
0
ratings
by
saphira
14 Feb 2008 08:51
Add a Comment
Show All Comments
[0]
Flag
1000 words left
Blurtit Tools:
Email to a Friend
Bookmark this page
Ask a Question
Related Questions
What Is The Importance Or
Significance Of Data
Management Systems?
What does SQL stand for?
How Can I Master Java
Without Any Coaching In
Institutes?
Can You Write A Program
For Towers Of Hanoi?
Will DCLGEN Convert
Whole SQL Quarries?
What is history of
database systems?
How Do You Make A Program
Regarding Two-Array
Functions?
I'm using a merge to
letter documents getting
data from Access
database as data source,
What Are The Topics For
Ocp?
How Can I Get Image From
Database And Save To One
Folder In Asp.net?
My Blurtit
My Profile
My Questions
My Answers
Blurtit Features
Ask a Question
Answer a Question
Search an Answer
Categories
Tools
Link to Blurtit
Add Blurtit to Firefox
Search Engine
See Your Site Here
Link to Blurtit
RSS
Blurtit.com
About Us
Terms & Conditions
Privacy Policy
Contact Us
Advertise With Us
Help
International
Chinese Site
Japanese Site
To continue you need to be registered with us first.
I am already a Blurter, and need to login
I am not a Blurter yet, but would like to register