how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 16751 Views
- I also Faced
- E-Mail Answers
Answer Posted / venakteswara rao
select upper(<colummn name>,1,1)+substring(lower(<column
name,2,len(<column name>))) as anyname from table name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the maximum size of a row? : Sql server database administration
How do we synchronize On-Premise SQL server with SQL Azure?
Explain about extended stored procedure?
What is a join in sql? What are the types of joins?
What is 2nf normalization form?
What is the purpose of a table?
What is bcp? When does it use?
Can you explain full-text query in sql server?
How to find related tables in sql server?
How to disconnect from a sql server using mssql_close()?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is "scheduled jobs" or "scheduled tasks"?
What is the difference between Normalization and De-normalization?
Explain ms sql server reporting services vs crystal reports?
What is full outer join in sql server joins?
