String functions in SQL

Linklist

• LENGTH - length of an string
• LEFT - get some characters from left
• RIGHT - get some characters from right
• SUBSTR - get some characters from an string
• TRIM - delete beginning and trailing spaces
• VALUE - convert an string to a number

LENGTH - length of an string

Syntax

LENGTH( Formula )

Description

Return the length of the string in characters.

LEFT - get some characters from left

Syntax

LEFT( Formula1 , Formula2 )

Description

Returns a number of characters, specifyed by Fomula2, from the left side of the argument Formula1.

RIGHT - get some characters from right

Syntax

RIGHT( Formula1 , Formula2 )

Description

Returns a number of characters, specifyed by Fomula2, from the right side of the argument Formula1.

SUBSTR - get a substring

Syntax

SUBSTR( Formula1 , Formula2 , Formula3 )

Description

Returns a substring from the argument Formula1, which starts at position Formula2 and is Formula3 characters long.

TRIM - delete beginning and trailing spaces

Syntax

TRIM( Formula )

Description

TRIM deletes all spaces form the left and right sides of the argument.

VALUE - convert into a number

DB2

Syntax

VALUE( Formula )

Description

Converts the string into a numeric value.