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

Which is faster mongodb or mysql?

897

What is different between sql and mysql?

1021

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

1063

how we will Show selected records sorted in an ascending (asc) or descending (desc).

988

What is difference between unix timestamp and mysql timestamp?

1014

Explain the difference between procedure and function in mysql?

993

What mysql -u john -p command does?

975

What is row locking in mysql?

967

What are the similarities between a function and a procedure?

896

What is heap table in mysql?

973

Is primary key auto increment?

947

Is mysql is a programming language?

994

What is pdo in php mysql?

947

explain GROUPBY & HAVING clause with examples.

2292

How to delete a trigger in mysql?

925