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
- 18552 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 right outer join in sql server joins?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is a trigger and types of a trigger?
How to return the second 5 rows in ms sql server?
What is the xml datatype?
why would you use sql agent? : Sql server database administration
What is importing utility?
Why are you getting errors when creating a new odbc dsn?
Explain transaction server distributed transaction?
what method you can use to reduce the overhead of Reporting Services data sources?
Which tcp/ip port does the sql server run on? How can it be changed?
What is the difference between upgrade and migration in sql server?
What are magic tables in sql server?
What's new in sql management studio for sql server? : sql server management studio
Can a table be created inside a trigger?
