select ucase(mid(Fname,1,1)) as FirstName,ucase(mid(Lname,1,1)) as LastNa

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 / vardhan rao

3 Answers
5225 Views
I also Faced
E-Mail Answers

Answer Posted / vardhan rao

select ucase(mid(Fname,1,1)) as
FirstName,ucase(mid(Lname,1,1)) as
LastName,ucase(mid(City,1,3)) as Cty,ucase(mid(Pin,-3))as
PinCode from empadd

Output:
FirstName LastName City Pincode
R K SAL 241

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is mysql command line?

971

Which command is used to view the content of the table in mysql?

867

How we can get distinct columns values in mysql?

1015

Explain the difference between delete and truncate.

937

Is mysql a framework?

871

What is truncate in mysql?

895

List some mysql advantages and disadvantages?

909

Does uninstalling mysql delete database?

950

What is delimiter in mysql stored procedure?

859

What is blob and text in mysql?

1111

What is blob datatype in mysql?

894

What is cursor in mysql?

843

How to find the unique values if the value in the column is repeated?

921

How to make a copy values from one column to another in mysql?

976

What is mysql database extension?

966