how to select a field with firstletter as capital and
remaining are small letters
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / velmurugan
Select UPper(Left(Company,1)) + Lower(Right(Company,Len
(Company)-1)) From Company
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
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 |
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 |
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 |
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 |
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 |
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Explain triggers?
What are the indexes in sql server?
Define outer join in sql server joins?
Explain about remote stored procedure?
How do I find the sql server instance name?
How to return the second 5 rows in ms sql server?
Please illustrate physical database architecture? : SQL Server Architecture
How to list all field names in the result set using mssql_field_name()?
Who developed sql server?
What is unique key constraint?
Can foreign key be duplicate?