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
5487 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 many entries can mysql handle?

1056

Is there a free mysql?

947

How do I export mysql query results to excel?

1013

how to take mysql database backup?

1126

What is a join in mysql?

957

How do I zip a file in mysql?

1026

What is the use of innodb in mysql?

1039

What is a storage engine?

1015

What is myisam?

1027

What are all the Common SQL Function?

1209

How MySQL Optimizes DISTINCT?

1165

How do I clear a mysql database?

1009

What is triggers and how it can be used in mysql?

1015

Why mysql is so popular?

1024

What is the default port for mysql and how it can change?

1108