Question
Virtusa
IN
Posted: Nov 8, 2023
Last activity: Nov 9, 2023
Last activity: 9 Nov 2023 1:05 EST
Solved
Contains function in report definition
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 :)
Thank you!
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Accepted Solution
Posted: 10 months ago
Updated: 10 months ago
Updated: 9 Nov 2023 1:05 EST
JPMC
IN
@RameshBattini tried this and seems to be working
Posted: 10 months ago
JPMC
IN
@RameshBattini We would need to right a function alias for this.
Posted: 10 months ago
Updated: 10 months ago
Updated: 8 Nov 2023 11:55 EST
Virtusa
IN
@BhanuPrakash_G Hey, thanks :)
But I know it, I need help with the SQL :)
Accepted Solution
Posted: 10 months ago
Updated: 10 months ago
Updated: 9 Nov 2023 1:05 EST
JPMC
IN
@RameshBattini tried this and seems to be working
Posted: 10 months ago
Virtusa
IN
@BhanuPrakash_G it got worked, thank you <3