Interested to Buy Any Domain ? << Click Here >> for more details...
how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 19376 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Will the writetext statement activate a trigger?
Does index speed up select statements?
Write a query for primary key constraint with identity key word?
what are the different types of SSRS reports?
What are examples of triggers?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is an identity?
What do you mean by an execution plan? Why is it used?
What is a filestream?
Explain the rules for designing files and file groups in sql server?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the five characteristics of good data?
What is the difference between seek predicate and predicate?
What are system databases into sql server (2005/2008) : sql server database administration
What is it’s similarity with sql server?
