Contains function in report definition

User Experience
, , ,
1

Hello Guys,

I have a requirement to check Prop1 contains Prop2 and returns column value as Y/N. I know we have pxFind function but it is returning positive integer(char position where prop2 starts) if condition satisfied.

please suggest if you have any ideas :slight_smile:

Thank you!

2

@BATTINIRAMESH We would need to right a function alias for this.

3

@BhanuPrakash_G Hey, thanks :slight_smile:

But I know it, I need help with the SQL :slight_smile:

4

@BATTINIRAMESH tried this and seems to be working

contains.png
contains.png290×103 3.41 KB

5

@BhanuPrakash_G it got worked, thank you <3