LIKE is used in Teradata to match string against a set of pattern which a user required. There are two wild card characters used in LIKE and they are – ‘_’ and ‘%’. ‘_’ is used for single character search. ‘%’ is used for multiple character search. For e.g. 1) Suppose we want to search …
