I am trying to do a Select on a table but I don't want the Select to be case sensitive. For example, if I am searching...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
for the 'Kansas' in the city field, all the records in that table having 'KANSAS' in the city field should be returned, upper and lower case. Is there any function or any statement I can use in my Select to ignore the case?
As far as I am aware, you cannot do this direct from ABAP. You may be able to do it using EXEC SQL, depending on the database you are using.
Dig Deeper on SAP ABAP
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header.continue reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location.continue reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.