Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5389 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
Why is mysql used?
Can we write procedure in mysql?
How to run 'mysql' commands from a batch file?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
How can you plan the logshipping before processing?
What does mysqli stand for?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How do I start mysql in ubuntu?
Is mysql free for enterprise?
What is pragma autonomous_transaction?
What is myisamchk?
How to calculate the difference between two dates?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
Is mysqli faster than mysql?
