In a Field A i'm getting value like 'HOW ARE YOU' OR 'WHERE YOU ARE' and i need to check whether 'ARE' is present in the incoming string or not.If it is present then i need to return 1 else 0.
How to i do this using
Thanks and Regards...
Use reg_match with the following syntax to find out 'ARE':
Use below one.
Use REG_MATCH(Col_Name,'.* ARE .*), the leading and laging space is important as it will ensure it only picks up the right word.
or else it will also pick up words 'HARE','AREA','ARES'...etc
You can try this.It worked for me.
REG_MATCH(Name_IN,'.* ARE .*')