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
- 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
What is mysql command line?
Which command is used to view the content of the table in mysql?
How we can get distinct columns values in mysql?
Explain the difference between delete and truncate.
Is mysql a framework?
What is truncate in mysql?
List some mysql advantages and disadvantages?
Does uninstalling mysql delete database?
What is delimiter in mysql stored procedure?
What is blob and text in mysql?
What is blob datatype in mysql?
What is cursor in mysql?
How to find the unique values if the value in the column is repeated?
How to make a copy values from one column to another in mysql?
What is mysql database extension?
