how to select a field with firstletter as capital and
remaining are small letters
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 are the joins in sql server? : sql server database administration
Can a table have 2 primary keys?
How will you make an attribute not process? : sql server analysis services, ssas
Explain optimistic and pessimistic concurrency?
Explain “not null constraint” in sql server?
What are the restrictions that views have to follow?
what are different types of raid configurations? : Sql server database administration
Which joins are sql server default?
How would you go about developing a ssrs report?
Show Practically Sql Server Views are updatable?
Mention what are the core components of ssrs?
Suggest a method of joining two tables.
tell me the disaster recovery plan
What is self contained multi valued query?
Can you explain full-text query in sql server?