SELECT * UPPER(SUBSTRING(<COLUMNNAME>,1,1)) +LOWER(SUBSTRING(<COL

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

Question Posted / priya

Answer Posted / priya

SELECT * UPPER(SUBSTRING(<COLUMNNAME>,1,1))
+LOWER(SUBSTRING(<COLUMNNAME>,2,LEN(<COLUMNNAME>))) AS
<SOMENAME> FROM <TABLENAME>

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how would you troubleshoot blocking? : Sql server database administration

945

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

854

Explain about service Broker functions?

985

What is row_number function?

944

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1130

What is a filestream?

945

What is the datatype of rowid?

877

How to move database physical files in ms sql server?

961

What is dbcc?

1084

Mention the 3 ways to get a count of the number of records in a table.

919

Why use “pivot” in sql server?

1045

What do you mean by an execution plan? Why is it used? How would you view it?

880

Define tempdb database?

944

What are the types of table?

921

What is the default port for SQL Server over a firewall?

1032