STRTOK Function Syntax | Teradata Vantage - STRTOK Function Syntax - Advanced SQL Engine - Teradata Database

[TD_SYSFNLIB.] STRTOK ( instring [, delimiter ] [, tokennum ] )

Syntax Elements

TD_SYSFNLIB.

Name of the database where the function is located.

instring

A character string or string expression.

If instring is NULL, NULL is returned.

delimiter

A list of delimiter characters. Each character in the string is considered a delimiter character.

If not specified, the value defaults to a space character.

tokennum

The ordinal token to return.

If not specified, the default value is 1.