Fungsi SQL BigQuery

Returns the ASCII value (code point) of the first character in the string.

Mengembalikan jumlah bytes dari STRING atau BYTES value.

Returns the number of characters in a string. An alias for LENGTH, available for standard SQL compatibility.

Converts a Unicode code point value into a string character. The inverse of the ASCII function.

Converts an array of code points (extended ASCII 0–255) into BYTES.

Converts an array of Unicode code points into a STRING.

Concatenates two or more strings into one. A foundational string concatenation function in BigQuery that supports multiple data types.

Checks whether a string contains a specified substring. Case-insensitive and supports JSON structures.

Checks whether a string ends with a specified suffix. Returns a boolean.

Menghitung fingerprint menggunakan algoritma FarmHash. Sangat cepat dan cocok untuk BigQuery.

Formats values into a string based on a format string (similar to printf). Supports a wide range of format specifiers.

Menghasilkan UUID (Universally Unique Identifier) versi 4 secara random.

Capitalizes the first letter of each word and lowercases the rest. Title case transformation.

Finds the position of a substring within a string. Supports searching from a specific position and locating the nth occurrence.

Extracts a specified number of characters from the left (beginning) of a string. A more readable shorthand than SUBSTR for extracting leading characters.

Returns the number of characters in a string. For BYTES, returns the number of bytes.

Converts all characters in a string to lowercase. Supports Unicode characters.

Pads the left side of a string with characters until it reaches a specified length. Left padding.

Removes characters from the left side (beginning) of a string. Left trim for leading characters.

Menghitung MD5 hash dari input. Return BYTES.

Normalizes a Unicode string to a canonical form. Useful for consistent string comparisons across different Unicode representations.

Normalizes a Unicode string and applies case-folding for correct Unicode-aware case-insensitive comparisons.

Returns TRUE if the value matches the regular expression. Useful for pattern matching and format validation.

Extracts the first substring that matches the regular expression. If the pattern has a capturing group, returns that group instead.