how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 17335 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
Explain about SQL server 2005?
How to execute stored procedure and set temp table in sql server?
How to disconnect from a sql server using mssql_close()?
What is the difference between getdate and sysdatetime?
What happens if null values are involved in bitwise operations?
How to get a list of columns using the "sys.columns" view in ms sql server?
Can we use trigger new in before insert?
Explain system scalar functions?
What is the difference between mysql and mysqli?
what is blocking? : Sql server database administration
What are pessimistic lock and optimistic lock?
What is tempdb database? : SQL Server Architecture
What do you mean by 'normalization'?
What is wide table?
Characterize join and name diverse sorts of joins?
