Teradata provides several functions to manipulate the strings. These functions are compatible with ANSI standard.
| Sr.No | String Function & Description |
|---|---|
| 1 | ||Concatenates strings together |
| 2 | SUBSTRExtracts a portion of a string (Teradata extension) |
| 3 | SUBSTRINGExtracts a portion of a string (ANSI standard) |
| 4 | INDEXLocates the position of a character in a string (Teradata extension) |
| 5 | POSITIONLocates the position of a character in a string (ANSI standard) |
| 6 | TRIMTrims blanks from a string |
| 7 | UPPERConverts a string to uppercase |
| 8 | LOWERConverts a string to lowercase |
Example
Following table lists some of the string functions with the results.
| String Function | Result |
|---|---|
| SELECT SUBSTRING(‘warehouse’ FROM 1 FOR 4) | ware |
| SELECT SUBSTR(‘warehouse’,1,4) | ware |
| SELECT ‘data’ || ‘ ‘ || ‘warehouse’ | data warehouse |
| SELECT UPPER(‘data’) | DATA |
| SELECT LOWER(‘DATA’) | data |