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
- 18563 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
What are system databases into sql server (2005/2008)?
What is application role in sql server database security? : sql server security
What is @@rowcount in sql?
What is mssql?
What is the difference between char, varchar and nvarchar?
How to convert character strings into numeric values?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is the default value of an integer data type in sql server 2005?
What are group functions in query statements in ms sql server?
Where can you add custom error messages to sql server?
How do I view a stored procedure in sql server?
What is conditional split?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Define tool Manage Statistics in SQL Server 2000 query ?
Explain the commands in sql server?
