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 to improve the speed of SQL database server and how to avoid dead lock?
Why use “pivot” in sql server?
What is raid, and how it can influence database performance?
According to you what goes into making the best database administrator? : sql server database administration
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
What new changes are being made in SQL Server?
What are the different Topologies in which Replication can be configured?
How to loop through returning rows?
What is BCNF? How is it better than 2NF & 3NF?
What information is maintained within the msdb database?
Can we insert data into view sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible