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
- 19366 Views
- I also Faced
- E-Mail Answers
Answer Posted / k.vanitha
CREATE TABLE Employee (NAME VARCHAR(20), SALARY int);
INSERT INTO employee VALUES (
'RAMESH',
9000);
INSERT INTO employee VALUES (
'RAJESH',
10000);
SELECT Left(upper(NAME),1) +
lower(substring(NAME,2,len(NAME))) FROM employee
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is de-normalization and what are some of the examples of it?
Explain what is log shipping?
How to create view in stored procedure sql server?
What are the security related catalog views? : sql server security
What does the update command do?
What samples and sample databases are provided by microsoft?
What is recompile sql server?
What is data mart? : sql server analysis services, ssas
How do I delete a sql server database?
In which format does an image save in SQL Server database ?
How to generate create function script on an existing function?
How can I check that whether automatic statistic update is enabled or not?
What is nested transaction?
What is 1nf normalization form?
