Teradata - String Manipulation

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

SUBSTR

Extracts a portion of a string (Teradata extension)
3

SUBSTRING

Extracts a portion of a string (ANSI standard)
4

INDEX

Locates the position of a character in a string (Teradata extension)
5

POSITION

Locates the position of a character in a string (ANSI standard)
6

TRIM

Trims blanks from a string
7

UPPER

Converts a string to uppercase
8

LOWER

Converts 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
Advertisements