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
- 19044 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
What is model database in sql server?
Define self join in sql server joins?
What is an identity column in insert statements?
How to connect to SQL Azure Database by using sqlcmd?
Can I run multiple instances of sql server 2000 at the same time on one computer?
what is blocking? : Sql server database administration
What is difference between index and primary key?
What is the function of sql server agent windows service?
What are cursors in ms sql server?
Difference between primary key and clustered index?
Can you explain what is sql server english query?
What is the difference between push and pull subscription? : sql server replication
What are the new features in sql server 2016?
Define full outer join?
What is sql language?
