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
- 5396 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 are the 'mysql' command line options?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
How to display nth highest salary from a table in a mysql query?
How can I see all mysql databases?
What is difference mysql and mysqli?
What is mysql and why it is used?
How do I start and stop mysql server?
Which statement is used in a select query for partial matching?
How to create a new table by selecting rows from another table in mysql?
What is mysql sleep process?
How to decrement dates by 1 in mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
Why is it called mysql?
What is mysql aggregate functions? Explain
Can mongodb replace mysql?
