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
5335 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

Explain about reporting services of MYSQL?

1052

How to rename an existing table in mysql?

1012

What is a mysql model?

926

Which is faster mongodb or mysql?

882

What is definer in mysql trigger?

898

How many entries can mysql handle?

978

What is RMS Migrations

2385

What is the usage of ENUMs in MySQL?

1103

Why is the basic difference between left join, right join and inner join?

1015

What is maximum table size in mysql?

927

What is heap table in mysql?

956

Why is mysql popular?

855

What happens if you no create privilege in a database?

1093

What are federated tables?

1158

What are the advantages of mysql?

976