Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

UltraLite String functions

String functions perform conversion, extraction, or manipulation operations on strings, or return information about strings.

When working in a multibyte character set, check carefully whether the function being used returns information concerning characters or bytes.

The following string functions are available:

• ASCII function [String]
• BYTE_LENGTH function [String]
• BYTE_SUBSTR function [String]
• CHAR function [String]
• CHARINDEX function [String]
• CHAR_LENGTH function [String]
• DIFFERENCE function [String]
• INSERTSTR function [String]
• LCASE function [String]
• LEFT function [String]
• LENGTH function [String]
• LOCATE function [String]
• LOWER function [String]
• LTRIM function [String]
• PATINDEX function [String]
• REPEAT function [String]
• REPLACE function [String]
• REPLICATE function [String]
• RIGHT function [String]
• RTRIM function [String]
• SIMILAR function [String]
• SOUNDEX function [String]
• SPACE function [String]
• STR function [String]
• STRING function [String]
• STRTOUUID function [String]
• STUFF function [String]
• SUBSTRING function [String]
• TRIM function [String]
• UCASE function [String]
• UPPER function [String]
• UUIDTOSTR function [String]