Need a Query to Display 1st two and last two Characters of String.
By: Sugandh | 12 May 2015 3:52 pm | 480 times viewed | 0 Comments
I need a query to display 1st two and last two characters of string like
Example: 'Bangaluru' is string
Output should be: Baru
Please share the answer here.
Thanks in advance.
No Comments Posted for this Article.
What is SAP Fiori, Course, Career and Certification?Definition - What is SAP Fiori?SAP Fiori is an amazing initiative from SAP to offer a faster and more responsive user interface. It applies state-of-the-art design principles for delivering simple, responsive and personalized experiences across various devices and deployment choices. This...
SAP to Boost Up the Oil and Gas SectorSAP as we all know is the market leader the of e-business software solutions in the world. By virtue of using mySAP.com e-business platform, all around the globe the businesses are improving their relationships with their esteemed partners as well as customers. The application allows them to...
Time to Boost Your Career with SAPHave you ever wondered why you didn't qualify for the position in a company for which you had applied sometime back? This can be very frustrating and disappointing for most of us especially when you know that the job involves all those skills which you possess by virtue of your past experience...
SAP Does It Again, Acquires AribaSAP a well- known German company did it once again, for delivering the very best to all its partners and customers the company acquired Ariba in the year 2012! The company has acquired brands like Fieldglass, SuccessFactors, Hybris and Ariba. SAP aimed at rebranding all four of these brands. Going...
Difference between SAP S/4HANA and SAP Suite on HANASAP S/4HANA Vs. SAP Suite on HANABetween SAP Suite on HANA and SAP S/4HANA, some level of confusion still exist which I got know after speaking with a large number of people. For those who are wrestling with the differences between the two products let me provide some clarity. Before making any...
I Need Query to Generate Email for Employees
This question asked in interview and even i don\'t know its possible or not.i need query to generate email for employees likeename starts with \'S\' then firstname.lastname@example.org starts with \'A\'...
SQL Financial Accounting Error..
Hi all, I have one problem regarding the SQL financial accounting software.When i run this software,it display this message: Exception EAccessViolation in module SQLAcc.exe at 000041f1 Access...
Now I Need to Take Out only Capital Letters.
Hello Experts, I need a query in SQL. here is the question: I have one column named as LETTERS, in that column both capital and small letters inserted so now I need to take out only capital...
How to Fetch Only the Character or Alpha Data?
Hello Experts,I am having one Column with data as abc,ÃÂ def,123,ÃÂ 446,ÃÂ xyz.I want to fetch only the character or alpha data. The output is abc, def, xyz with three records. Can...