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
5339 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 max_used_connections in mysql?

931

What is 'mysqlshow'?

1033

How can we optimize stored procedure?

937

What is slow query log in mysql?

1079

Is mysql a backend?

916

How do you concatenate strings in mysql?

992

Can mysql store files?

916

How do I create a database in mysql workbench?

854

How to shut down the server with 'mysqladmin'?

959

What is a string in mysql?

883

How do you backup a database in mysql?

1053

Is mysql distributed?

908

What is the maximum size of mysql database?

934

Why myisam is faster than innodb?

921

What is the current root password of mysql?

896