Teradata - String Manipulation


Advertisements

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