select substr(ucase(Fname),1,1), substr(ucase(Lname),1,1), substr(ucase(Ci

Fname Lname City Pin
ramesh kumar salem 365241

Query to generate a code having the firstletter of
Fname,Lname & 3letter of city Last 3letter of pin,all in
capital letters

Question Posted / sonali

3 Answers
5226 Views
I also Faced
E-Mail Answers

Answer Posted / sonali

select substr(ucase(Fname),1,1), substr(ucase(Lname),1,1),
substr(ucase(City),1,3), mid(Pin,-3) from emp

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to delete an existing column in a table?

887

What is mysql in linux?

955

How to delete a column and add a new column to database

894

How to return query output in xml format?

983

How do I install mysql?

843

How set mysql root password?

873

Differentiate CHAR_LENGTH and LENGTH?

937

What is mysql_connect?

902

How do you kill a long running query in mysql?

838

What is strict mode in mysql?

843

What you can use regular expression for in mysql? Support your answer with an example?

843

How many ways to get the current time?

919

What is 'mysqladmin' in mysql?

972

Can we write pl sql mysql?

894

Is mysql free for enterprise?

852