--- cuppy_hub: salesforce cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/string-func.md cuppy_section: docs cuppy_doc: GVCC-G2HR cuppy_doc_uuid: 33636ed3-be50-4c38-90d1-0e6bbe92e91a cuppy_permalink: https://cuppy.io/salesforce/d/GVCC-G2HR cuppy_version: 1 cuppy_updated: 2026-10-23T16:16:52.575Z cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/string-func cuppy_mcp: https://cuppy.io/mcp cuppy_body_sha256: d5322fb61bc5d857ebe59760226dfdc3f04a9aeedbc2b3bfd53ea35cca424ec0 # cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks. --- > Mirror of (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers. ## String Functions and Operators **Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API Functions and operators for examining and manipulating string values. Use string functions to: * **Transform case** by converting strings to uppercase, lowercase, or title case. * **Extract and search** substrings, find positions, and split text. * **Pad and trim** strings to adjust length and remove unwanted characters. * **Encode and hash** data for storage or security purposes. * **Character and byte length**: Functions like `char_length` count characters, but `octet_length` counts bytes. This distinction matters for multi-byte UTF-8 characters. * **1-based indexing**: String positions start at 1, not 0. * **NULL handling**: The `||` operator returns NULL if either operand is NULL. Use `concat` to ignore NULL values. For more information about supported types, see [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string.html). Combine strings and values: * [CONCAT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/concat.html) — Concatenate multiple values, ignoring NULLs. * [String Concatenation Operator (||)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/concatenation-operator.html) — Concatenate two strings or a string and a non-string value (`NULL`-sensitive). Measure string size: * [BIT_LENGTH](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bit-length.html) — Get the number of bits in a string. * [CHAR_LENGTH / CHARACTER_LENGTH](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/char-length.html) — Count the number of characters in a string. * [LENGTH](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/length.html) — Count the number of characters in a string. * [OCTET_LENGTH](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/octet-length.html) — Get the number of bytes in a string. Transform string case: * [INITCAP](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/initcap.html) — Capitalize the first letter of each word. * [LOWER](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/lower.html) — Convert to lowercase. * [UPPER](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/upper.html) — Convert to uppercase. Extract and locate substrings: * [LEFT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/left.html) — Get the first _n_ characters. * [OVERLAY](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/overlay.html) — Replace a substring at a position. * [POSITION](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/position.html) — Find the location of a substring. * [RIGHT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/right.html) — Get the last _n_ characters. * [SPLIT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/split.html) — Split a string into an array by delimiter. * [SPLIT_PART](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/split-part.html) — Split a string on delimiter and return a field. * [STRPOS](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/strpos.html) — Find substring location (alternative syntax). * [SUBSTR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/substr.html) — Extract a substring (alternative syntax). * [SUBSTRING](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/substring.html) — Extract a substring by position and length. Adjust string length: * [BTRIM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/btrim.html) — Remove characters from both ends. * [LPAD](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/lpad.html) — Pad a string on the left. * [LTRIM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/ltrim.html) — Remove characters from the start. * [RPAD](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/rpad.html) — Pad a string on the right. * [RTRIM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/rtrim.html) — Remove characters from the end. * [SPACE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/space.html) — Generate a string of spaces. * [TRIM](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/trim.html) — Remove characters from start, end, or both. Transform and manipulate strings: * [REPEAT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/repeat.html) — Repeat a string multiple times. * [REPLACE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/replace.html) — Replace all occurrences of a substring. * [REVERSE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/reverse.html) — Reverse the characters in a string. Check for substrings and string boundaries: * [CONTAINS / ICONTAINS](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/contains.html) — Check whether a string contains a substring. * [ENDS_WITH](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/ends-with.html) — Check whether a string ends with a suffix. * [STARTS_WITH](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/starts-with.html) — Check whether a string starts with a prefix. Convert between characters and codes: * [ASCII](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/ascii.html) — Get the ASCII code of the first character. * [CHR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/chr.html) — Get the character for an ASCII code. Encode data and compute hashes: * [DECODE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/decode.html) — Decode text to binary data. * [ENCODE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/encode.html) — Encode binary data to text (base64, hex, escape). * [MD5](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/md5.html) — Compute the MD5 hash for data. * [SHA256](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/sha256.html) — Compute the SHA-256 hash for data. * [TO_BASE64](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-base64.html) — Convert data to base64. * [TO_HEX](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-hex.html) — Convert data to hexadecimal. Prepare strings for SQL statements: * [QUOTE_IDENT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/quote-ident.html) — Quote a string as an SQL identifier. * [QUOTE_LITERAL](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/quote-literal.html) — Quote a string as an SQL literal. Normalize and clean user input. Extract components from structured strings. Format data for display. Find and modify text patterns. * [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string.html) * [String Pattern Matching](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/string-matching.html) * [Data Type Formatting Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/formatting-func.html) --- You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.