Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
how to change first letter capital through MY sql
This is a discussion on how to change first letter capital through MY sql within the MY SQL forums, part of the Databases category; hi friends , now am working PHP Language ,am new for this field in that i have one Question about how to change first letter capital and remaining are small ...
|
|||||||
07-25-2009
|
|||
|
|||
|
how to change first letter capital through MY sql
hi friends , now am working PHP Language ,am new for this field in that i have one Question about how to change first letter capital and remaining are small in names field of my Table by using My Sql .so help me
|
| Sponsored Links |
|
07-27-2009
|
|||
|
|||
|
Re: how to change first letter capital through MY sql
select concat( upper(substring(Col_Name,1,1)),lower(substring(Col_Name,2)) )
from Table_Name -- Note : Replace the Table_Name and Col_Name with your actual tablename and column.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Verify whether text is capital letter or minuscule | auliksqa | Rational Robot | 0 | 10-29-2008 01:31 PM |
| Countries Capital DropdownList | ushalakshmi | ASP.NET | 4 | 05-23-2008 08:26 AM |
| change drive letter | sarathi trichy | Windows | 2 | 03-18-2008 09:06 PM |
| Covering Letter | sutnarcha | Resume Help | 3 | 10-25-2007 07:33 AM |
| Can I get 1st and last letter of emp name same time | Geek_Guest | Oracle | 4 | 05-09-2007 08:22 AM |
All times are GMT -4. The time now is 04:30 PM.
