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).
 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
 Flag

1000 words left

    


Blurtit Tools:  Email to a Friend    Bookmark this page
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