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
- 5489 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
How many rows can mysql hold?
What is the use of mysql_fetch_array () function in php?
What is the difference between myisam dynamic and myisam static in mysql?
How to connect html form to mysql database using php?
Which datatype is used for email in mysql?
What is max connection in mysql?
Can python connect to mysql?
What is the difference between truncate and delete in mysql?
How do I assign a variable in mysql?
Write a query to display current date and time?
Write a query to fetch duplicate records from a table using mysql?
Is mysql relational?
How do I create a schema in mysql?
What is difference between oracle and mysql?
How do I find the database name in mysql?
