Select Left(Upper((YourColumnName), 1) + Substring(Lower (YourColumnName),

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

Question Posted / dharmendra k dixit

Answer Posted / dharmendra k dixit

Select Left(Upper((YourColumnName), 1) + Substring(Lower
(YourColumnName),2,Len(YourColumnName))AS UName
From YourTableName

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to view existing indexes on an given table using sys.indexes?

1038

What is scheduled job and how to create it?

925

When multiple after triggers are attached to sql table, how to control the order of execution?

981

What is sql server english query?

1041

What is the use of partition by in sql server?

884

Detail about query optimizer?

1037

What is named query? : sql server analysis services, ssas

909

Can we linked SharePoint to a SQL database?

974

Is mysql the same as sql server?

914

What is bit data type?

981

What is the index requirement in SQL Azure?

What is difference between equi join and inner join?

860

What are various aggregate functions that are available?

918

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2708

Can we do dml on views?

918