cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

How to implement like function in bods?

0 Likes
View Entire Topic
werner_daehn
Active Contributor
0 Likes

I read the question as "Is there a 'like' operator in Data Services similar to SQL?".

Yes: https://help.sap.com/viewer/8092b085a68941f6aaa6708685a62b0d/4.2.11/en-US/576c21606d6d1014b3fc9283b0...

Example: The mapping of a column could be

ifthenelse(gender like 'f%', 'female', 'not female')

I know the Operators are listed in the docs under the chapter Scripting but the same syntax can be used in mappings and where clauses also.