Functions on Strings

There are various built-in functions on strings. In any string, position starts at 0 and ends at length - 1.

If you want to follow along with the examples, see Sample data to run queries to view a sample data and use the scripts to load sample data for testing. The scripts create the tables used in the examples and load data into the tables.

• substring function
• concat function
• upper and lower functions
• trim function
• length function
• contains function
• starts_with and ends_with functions
• index_of function
• replace function
• reverse function
• Examples using QueryRequest API