Interested to Buy Any Domain ? << Click Here >> for more details...
how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 19040 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh kumar chhotaray
SELECT UPPER(SUBSTRING(<FieldName>,1,1))+LOWER(SUBSTRING(Name,2,LEN(<FieldName>))) AS
alliasename FROM tablename
Example
--------
SELECT UPPER(SUBSTRING(Name,1,1))+LOWER(SUBSTRING(Name,2,LEN(Name))) AS
name FROM tblInfo
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do indexes help, types?
Explain having clause?
What are different types of join?
Explain transaction server explicit transaction?
When would you prefer to have a minimum number of indexes?
What is transaction server distributed transaction?
How to assign null values to variables or columns?
Explain few of the new features of sql server 2008 management studio
How to create a new table in a given schema?
How to create prepared statements using odbc_prepare()?
What are system databases in ms sql server?
When columns are added to existing tables, what do they initially contain?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Why main is user defined function?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
