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

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

More SQL Server Interview Questions

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  


Explain triggers?

0 Answers  


What are the indexes in sql server?

0 Answers  


Define outer join in sql server joins?

0 Answers  


Explain about remote stored procedure?

0 Answers  






How do I find the sql server instance name?

0 Answers  


How to return the second 5 rows in ms sql server?

0 Answers  


Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  


How to list all field names in the result set using mssql_field_name()?

0 Answers  


Who developed sql server?

0 Answers  


What is unique key constraint?

0 Answers  


Can foreign key be duplicate?

0 Answers  


Categories