how to select a field with firstletter as capital and
remaining are small letters
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
Does group by sort data?
What is query optimizer in sql server?
Can you explain what is sql server english query?
What are the types of indexing?
How sql server enhances scalability of the database system?
What is create command?
What is the difference between migration and upgradation in sql server?
What is measure group, measure? : sql server analysis services, ssas
Why do you need a sql server?
Define candidate key, alternate key, and composite key.
What are the types of joins in sql?
Can you import Microsoft Excel data to SSRS?
What is an execution plan? How would you view the execution plan?
Where are sql server usernames and passwords stored in the sql server?
How to create a user to access a database in ms sql server using "create user" statements?