Teradata 简明教程

Teradata - String Manipulation

Teradata 提供了多个函数来处理字符串。这些函数与 ANSI 标准兼容。

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