Jump to main content
Yellowbrick Documentation
Product Documentation
yellowbrick.com
Technical Support
ⓘ
Documentation Version 5.2
Search
Home
Documentation Version 5.2
SQL Reference
SQL Functions and Operators
String Functions
Documentation Version 5.2
What's New in Version 5.2
System Management
Client Tools and Drivers
ybsql Reference
Database Administration
Loading and Unloading Data
Workload Management
Backup and Restore
Database Replication
SQL Reference
SQL Data Types
SQL Commands
SQL Functions and Operators
Supported Functions and Return Types
SQL Conditions
String Functions
ASCII
BIT_LENGTH
BTRIM
CHAR_LENGTH
CHR
CONCAT, ||
CONCAT_WS
DECRYPT (deprecated)
DECRYPT_KS
DLE_DST
ENCODE
ENCRYPT (deprecated)
ENCRYPT_KS
HASH
HASH4
HASH8
HMAC
HMAC_KS
INITCAP
INSTR
LE_DST
LEFT
LENGTH
LOWER
LPAD
LTRIM, RTRIM
MD5
NYSIIS
OCTET_LENGTH
POSITION
REPEAT
REPLACE
REVERSE
RIGHT
RPAD
SPLIT_PART
STRPOS
SUBSTR
SUBSTRING
TO_ASCII
TO_HEX
TRANSLATE
TRIM
UPPER
Pattern Matching
Datetime Functions
Mathematical Functions
Aggregate Functions
Window Functions
Conditional Expressions
Formatting Functions
Type-Safe Casting Functions
JSON Functions
CONVERT (SQL Server Migration Function)
GETBIT Function
NEXTVAL Function
System Functions
Network Address Functions
SQL Reserved Words
SQL Quick Reference
Error Codes
Glossary
Notices and Licenses
String Functions
This section describes functions that operate on character strings.
ASCII
BIT_LENGTH
BTRIM
CHAR_LENGTH
CHR
CONCAT, ||
CONCAT_WS
DECRYPT (deprecated)
DECRYPT_KS
DLE_DST
ENCODE
ENCRYPT (deprecated)
ENCRYPT_KS
HASH
HASH4
HASH8
HMAC
HMAC_KS
INITCAP
INSTR
LE_DST
LEFT
LENGTH
LOWER
LPAD
LTRIM, RTRIM
MD5
NYSIIS
OCTET_LENGTH
POSITION
REPEAT
REPLACE
REVERSE
RIGHT
RPAD
SPLIT_PART
STRPOS
SUBSTR
SUBSTRING
TO_ASCII
TO_HEX
TRANSLATE
TRIM
UPPER