1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to select a field with firstletter as capital and
remaining are small letters

Question Posted / santosh kumar chhotaray

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


Please Help Members By Posting Answers For Below Questions

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

617

Can you explain what are commit and rollback in sql?

483

Does view occupy space?

509

Can you explain what is sql server english query?

537

What happens when unicode strings concatenate with non-unicode strings?

545




What is pessimistic concurrency?

538

Are semicolons required at the end of sql statements in sql server 2005?

565

Explain different types of collation sensitivity?

525

What is instead of dml trigger?

579

What is mssql?

564

Explain how to use linked server?

557

Can you move the resources after pausing the node? : sql server database administration

589

Explain about extended stored procedure?

484

Where are full-text indexes stored?

563

What is view in sql?

557