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 is acid mean in sql server?

1041

Can two tables share the same primary key?

858

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

889

Why is replication required on the sql server?

1010

What is Sqlpaging in SqlServer 2005 ?

1016

explain extended properties

929

What is table valued function and scalar valued functions?

990

Does partitioning improve performance?

920

What does it mean if @@cursor_row returns a negative number?

943

Why use triggers?

969

What are date and time data types in ms sql server?

1022

what is checksum in sql server.........???

1623

What is a trace frag? Where do we use it?

1047

How to convert a table data in XML format in sql server?

2495

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

945