how to select a field with firstletter as capital and
remaining are small letters
Answer Posted / vidit tyagi
SELECT Left(upper(<field_name>) , 1) + lower(substring
(<field_name>,2,len(<field_name>))) AS SomeName
FROM <table_name>
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the dis_advantages of stored procedures, triggers, indexes?
How to execute a sql statement using mssql_query()?
explain databases and sql server databases architecture? : Sql server database administration
what is a traditional network library for sql servers? : Sql server database administration
How to get the query of a table in sql server?
Can We Use Data-grids For Our Report In Ssrs?
What are the source of constraints?
State the difference between union and union all?
What is lock escalation? : sql server database administration
Explain what is the difference between a local and a global temporary table?
where can you add custom error messages to sql server? : Sql server administration
How does using a separate hard drive for several database objects improves performance right away?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Can the “if update (colname)” statement be used in a delete trigger?
How to add more data to the testing table in ms sql server?