
	Home > SAP software/management Tips > SAP Basis administration tips > Select Text fields: Case-insensitive

SAP Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

SAP BASIS ADMINISTRATION TIPS

Select Text fields: Case-insensitive

Carsten Wagener
07.02.2008
Rating: -5.00- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

Searching for strings (parts or with pattern) is cumbersome if the table field isn't defined as case-insensitive.

Example:

Search all requests in "E07T" where "AS4TEXT" contains "Sales."

With a...

To read more you must become a member of SearchSAP.com

As an existing member of the TechTarget network please activate your SearchSAP.com account

By joining SearchSAP.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.

TechTarget cares about your privacy. Read our Privacy Policy

Digg This! StumbleUpon Del.icio.us

RELATED CONTENT

SAP workflow development

How to do additional dialog processing after SAP COMMIT WORK statement

SAP TechEd Demo Jam 2009: Winners use beer keg in demo

How to replace a cancelled SAP workflow item

Retrieving content from an SAP workflow attachment

Changing reserved status of a workflow item

Why you shouldn't change SAP-related workflows in an SWUI

Finding BADIs you can use

Using change documents to update a Z table

Approving workflows from Outlook

Calling a custom workflow

SAP ABAP/Java developer tips

How to do additional dialog processing after SAP COMMIT WORK statement

How to find a piece of SAP ABAP code without debugging

How to read an SAP transaction in an ABAP code

How to provide an SAP R/3 4.5B application server with a Web service interface

How to find owners and transports of deleted ABAP programs

Fixing a common OPEN_FORM and START_FORM error in SAPscript

Is this the quickest way to find a BADI?

Easily debug error messages in SAP processes

Accessing private attributes in ABAP Objects

Improving performance with ABAP Objects in SAP Workflow

SAP Basis administration tips

Converting from MDMP to Unicode

Can SAP developer include authority check for S_TCODE in a called transaction?

How to fix Smart Forms printing double purchase orders

Deriving the name of a Smart Style from a Smart Form

SAP FI/CO consultant's role during upgrade from R/3 to ECC 6.0

Alternatives to downloading a trial version of SAP IDES ERP software

Verifying data consistency in production SAP FI/CO system when restoring a backup

How to upgrade DB2 on SAP R/3 4.7

How to create a snapshot from NAS and SAN of Oracle database

How to clone an SAP ECC 6.0 instance

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

normal SELECT * FROM E070T WHERE AS4TEXT LIKE gv_text" values like SALES or sales will not be found.

By using EXEC-SQL, there's a way to do this selection Case-insensitive:

Code

Rate this Tip

To rate tips, you must be a member of SearchSAP.com.
Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

NetWeaver SAP White Papers

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy SearchSAP.com is a search service provided by TechTarget and is completely independent of and not affiliated with SAP AG.