Skip to Content

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

Extract data where it begins wiht certain leters

Hello,

I have for all entries for 5 tables but I need to extract all the data where it begins with certain leters like "ab". how can I define that in my select. Thanks

Former Member
Former Member replied

You can use wild card characters like '%' in Where class,

... WHERE CITY LIKE '%town%'.

This condition is true if the column CITY contains a string containing the pattern u2018townu2019.

... WHERE NAME NOT LIKE '_n%'.

This condition is true if the column NAME contains a value whose second character is not u2018nu2019.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question