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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / prasad

11 Answers
18560 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / radhika

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

Is This Answer Correct ?

6 Yes

4 No

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

Answer / 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

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

Answer / velmurugan

Select UPper(Left(Company,1)) + Lower(Right(Company,Len
(Company)-1)) From Company

Is This Answer Correct ?

2 Yes

1 No

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

Answer / k.vanitha

CREATE TABLE Employee (NAME VARCHAR(20), SALARY int);

INSERT INTO employee VALUES (
'RAMESH',
9000);
INSERT INTO employee VALUES (
'RAJESH',
10000);

SELECT Left(upper(NAME),1) +
lower(substring(NAME,2,len(NAME))) FROM employee

Is This Answer Correct ?

3 Yes

2 No

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

Answer / bobby

select ascii('a')as a,ascii('z')as z

select ascii('A')as A,ascii('Z')as Z

select * from Table_name where (ascii(<COLUMNNAME>))
between 65 and 90)and
ascii(substring(<COLUMNNAME>,2,1)) between 97 and 122

Is This Answer Correct ?

2 Yes

1 No

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

Answer / amit shukla

select upper(left(h01_first_name,1))
+lower(substring(rtrim(h01_first_name),2,50)) as name from
<table name>

Is This Answer Correct ?

1 Yes

0 No

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

Answer / 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

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

Answer / 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

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

Answer / venakteswara rao

select upper(<colummn name>,1,1)+substring(lower(<column
name,2,len(<column name>))) as anyname from table name

Is This Answer Correct ?

0 Yes

0 No

Post New Answer