SQL wildcards are special characters that can substitute for one or more characters in a string. They are often used with the LIKE operator to search for partial or fuzzy matches in text data.

These string operators are available in data lake Relational Engine. String concatenation (two vertical bars). If either string is the NULL value, then the string is treated as the empty string for ...