sql function tableau-api amazon-quicksight sql-query-store

Substitute for CONTAINS function in QUICK SIGHT

What is the Substitute/alternate function for CONTAINS function in Amazon Quicksight. Or any function that can be used in the backend (in Redshift).

Solution

I think you are looking for locate. If a substring is not contained in a string, locate returns 0

locate(expression, substring, start)

Documentation

Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
SQL Management Studio can't drag table / object from Explorer to Query Editor
How can I put a where condition on a SqLite view statement?
Get 2 Digit Number For The Month
Set a column unique without being the primary key
How to simulate a deadlock in SQL Server in a single process?
"The big SQL RegEx": How do I RegEx split a SQL query?
Determine column to insert into based on content
Can a 4 column address be merged into a 2 columns address with a SELECT statement?
How to write a "recursive update"?
hierarchical query in Oracle
How to Select all Columns from a Table for a Record - but to exclude a Column if all entries for that Record in said Column are null?
Find patients admitted multiple times for the same primary diagnosis in SQL
Updating SQL Server records with replace
Export data from dynamic XML hierarchy in SQL Server
How to resolve this error Ora-25137 "Data Value Out of range" in oracle
Writing a SQL Query with multiple Where statements
VBA - Convert a few numeric cells as text
MySql: unknown column id in 'field list'
SQL Server TDS protocol response problem when calling a stored procedure
Can Postgres use the foreign key (between two tables) as the "ON" clause when LEFT JOINing them?
Count matching value in two columns in SQL
Why UNION and UNION ALL don't work in my code?
Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint
PostgreSQL: Give all permissions to a user on a PostgreSQL database
How does group by works in sequelize?
Cursor bug when editing sql file
Add a given value from a column based on the value from another column
How can I make SQL case sensitive string comparison on MySQL?
How to fix "java.sql.SQLException: Can't call commit when autocommit=true"