how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 17355 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the sql case statement used for?
What happens when converting big values to numeric data types?
How to connect a database with sql express.?
Explain indexed views and partitioned view with their syntax.
What is microsoft sql server?
Differentiate between SQL and ORACLE joins and write their syntax.
What is difference between rownum and rowid?
Do you know what are different types of replication in sql server?
What is the synonym of join?
What happens if you add a new index to large table?
Explain tablesample?
what is database replicaion? : Sql server database administration
What is cursors?
what are cursors? : Sql server database administration
What are the events recorded in a transaction log?
