Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to select a part of the filed in SELECT??

Hi all,

I want to get a part in the field of table to compare with a string. But the LIKE syntax is poor efficiency. Who can give another way. thx in advance.

Eg:

SELECT *

FROM TAB1

INTO IT_TAB1

WHERE FIELD1 = '2008'.

But in the FIELD1 is '2008AAAA', I want to compare '2008' with the frontal 4 char.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question