how to select a field with firstletter as capital and
remaining are small letters
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
Explain insert into select statement?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is the full form of ddl?
What is the rdl file?
What is failover clustering overview?
How to get a list of columns using the "sys.columns" view in ms sql server?
What are the restrictions that views have to follow?
What types of Joins are possible with Sql Server?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is the purpose of the model database?
Which sql server table is used to hold the stored procedure scripts?
What is dbcc updateusage?
what stored procedure can you use to display the current processes? : Sql server administration
How are the exceptions handled in sql server programming?
Why would you use sql agent?