Using regular expressions on Teradata

To identify incorrect data, you may want to use Pattern indicators. These indicators use regular expression to work. In Teradata, the regular expression function is only installed by default starting from version 14.

To use the regular expression function in a Teradata version prior to 14, you need to install a User Defined Function (UDF).