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
- 18701 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 are the new scripting capabilities of ssms? : sql server management studio
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Is sql server a database?
Please explain go command in sql server?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is the difference between insensitive and scroll cursor?
Which are new data types introduced in sql server 2008?
Explain differences between web edition and business edition?
What number aggregate functions are accessible there in sql?
What is difference between view and materialized view?
What is the difference between NOROW and LOCKROW?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What are the differences between char and varchar in ms sql server?
What is RMS migrations?
What is 2nf normalization?
