What is the Substitute/alternate function for CONTAINS function in Amazon Quicksight. Or any function that can be used in the backend (in Redshift).
I think you are looking for locate. If a substring is not contained in a string, locate returns 0
locate(expression, substring, start)