# String and Search Functions
<a name="sql-reference-string-and-search-functions"></a>

The topics in this section describe the string and search functions for Amazon Kinesis Data Analytics streaming SQL.

**Topics**
+ [CHAR\$1LENGTH / CHARACTER\$1LENGTH](sql-reference-char-length.md)
+ [INITCAP](sql-reference-initcap.md)
+ [LOWER](sql-reference-lower.md)
+ [OVERLAY](sql-reference-overlay.md)
+ [POSITION](sql-reference-position.md)
+ [REGEX\$1REPLACE](sql-reference-regex-replace.md)
+ [SUBSTRING](sql-reference-substring.md)
+ [TRIM](sql-reference-trim.md)
+ [UPPER](sql-reference-upper.md)