SELECT UPPER(SUBSTRING(<FieldName>,1,1))+LOWER(SUBSTRING(Name,2,LEN(

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

Question Posted / santosh kumar chhotaray

11 Answers
18913 Views
I also Faced
E-Mail Answers

Answer Posted / santosh kumar chhotaray

SELECT UPPER(SUBSTRING(<FieldName>,1,1))+LOWER(SUBSTRING(Name,2,LEN(<FieldName>))) AS
alliasename FROM tablename

Example
--------
SELECT UPPER(SUBSTRING(Name,1,1))+LOWER(SUBSTRING(Name,2,LEN(Name))) AS
name FROM tblInfo

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the truncate command? : SQL Server Architecture

1141

What is built-in function?

978

What do you understand by a view? What does the with check option clause for a view do?

983

What is the difference between a view and a stored procedure?

1016

What is blocking?

1040

what are the different ways to return the rowcount of a table?

978

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1044

What are the diifferences between the ms sql server vs mysql?

1157

What is constraints and its types?

922

What are triggers in ms sql server?

1142

What are the indexes in sql server?

1095

What is default constraint in ms sql server?

1003

What is the return type of executeupdate ()?

886

How to add more data to the testing table in ms sql server?

1058

What are data resources?

892