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 is a full-text index updated?

955

What is the template in sql?

979

Explain foreign key in sql server?

1031

Where views are stored in sql server?

987

What do you understand by physical_only option in dbcc checkdb?

981

Is it possible to replicate data from sql server to oracle? : sql server replication

1096

What is oltp (online transaction processing)?

1010

How do I find the query plan in sql server?

962

What is data block and how to define data block size?

1027

What is a file group?

1093

What are the source of constraints?

931

Can we linked SharePoint to a SQL database?

1029

What is the difference between char, varchar and nvarchar?

1024

Which are ddl commands?

1048

How to change the ownership of a schema in ms sql server?

1195