SELECT Left(upper(<field_name>) , 1) + lower(substring (<field

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

Question Posted / vidit tyagi

Answer Posted / vidit tyagi

SELECT Left(upper(<field_name>) , 1) + lower(substring
(<field_name>,2,len(<field_name>))) AS SomeName
FROM <table_name>

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the recovery models for a database?

1146

How to delete all rows with truncate table statement in ms sql server?

1045

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

946

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1072

What are the various editions of sql server 2017 that are available in the market?

937

How do I view a stored procedure in sql server query?

979

What is the meaning of sql server?

1036

How the authentication mode can be changed?

1176

What are the differences between char and nchar in ms sql server?

1142

Is foreign key a primary key?

1177

What is raid? : SQL Server Architecture

1226

What are the reporting services components?

144

What is the largest component inside a field?

1187

What is the fastest way to permanently delete a 1 million row table named customers?

1327

How to find index size for each index on table?

1053