LIKE for List Of Values in Teradata

If we want to search for a list of values, we can search using square brackets. In this example, we want to select all those rows which have 'a','e','i','o' or 'u' as data in my column.

SELECT * FROM TBL_MYTABLE WHERE MYCOL LIKE '[aeiou]'


We can also exclude a list of characters. Like in the example below, we are excluding all rows where value of MYCOL starts with any of 'a','e','i','o' or 'u':
 SELECT * FROM TBL_MYTABLE WHERE MYCOL LIKE '[^aeiou]%'