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
- 5331 Views
- I also Faced
- E-Mail Answers
Answer Posted / mdeva
select ucase(mid(Fname,1,1)) as
FirstName,ucase(mid(Lname,1,1)) as
LastName,ucase(mid(City,3,1)) as Cty,ucase(mid(Pin,-3))as
PinCode from tablename
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is mysql primary key?
How to see table's field formats or description of table .
What is mysql cursor?
What is difference between inner vs self vs cross?
How to decrement dates by 1 in mysql?
Why phpmyadmin is used for mysql?
Is mysql case-sensitive?
What is mysqli procedural?
How large can a mysql database become?
How to use 'mysql' to run sql statements?
What are the technical features of MySQL?
What is blob and clob?
How many rows can a mysql table hold?
Where the database is stored in mysql?
What is the datatype for password in mysql?
