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
- 5224 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 to concatenate two character strings?
What are triggers mysql?
What is mysql root?
what is the procedure to configure the application of mysql?
How to delete a table.
How do I rename a table in mysql?
How many columns can a mysql table have?
What are the functions used to encrypt and decrypt the data present in mysql?
How can an index be declared in mysql?
What is dblink?
What is slow query log in mysql?
What is the date format in mysql?
What are the column comparisons operators?
What are the differences between binary and varbinary?
What is horizontally scalable?
