The functions BIT_LENGTH, CHAR_LENGTH, CHAR_LENGTH64, CHARINDEX, LOCATE, OCTET_LENGTH, SUBSTRING, SUBSTRING64, and PATINDEX support LONG VARCHAR data.
The LONG BINARY functions BYTE_LENGTH64, BYTE_SUBSTR64, and BYTE_SUBSTR also support LONG VARCHAR data. See “Function support of LONG BINARY data type” for descriptions of these functions.
See “CHAR_LENGTH function [String],” “CHARINDEX function [String],” “LOCATE function [String],” “SUBSTRING function [String],” and “PATINDEX function [String]” in Chapter 4, “SQL Functions” of Reference: Building Blocks, Tables, and Procedures for full descriptions and examples of the functions that support LONG VARCHAR.
