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
- 19378 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 we create SQL Server 2005 Reporting Services ? Give me Sample
How to generate create table script on an existing table in ms sql server?
What is cross join in sql server joins?
How can you set the threshold at which sql server will generate keysets asynchronously?
Explain what is the purpose of sql profiler in sql server?
Can you explain the disadvantages/limitation of the cursor?
how can a database be repaired? : Sql server administration
What is acid properties?
How to create a store procedure with encryption?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How to include date and time values in sql statements?
Explain different types of index?
Explain what is the difference between a local and a global temporary table?
which backup strategy you are following at ur company
What is the difference between rank and dense_rank?
