Byte Functions |
Table: Byte Functions lists the OLAP DML statements that you use to manipulate text based on bytes.
Byte Functions
| Statement | Description |
|---|---|
| CHANGEBYTES
|
Changes one or more occurrences of a specified string in a text expression to another string. |
| EXTBYTES
|
Extracts a portion of a text expression using bytes. |
| FINDBYTES
|
Returns the byte position of the beginning of a specified group of bytes within a text expression. |
| INSBYTES
|
Inserts one or more bytes into a text expression. |
| INSTRB
|
Searches a string for a substring using bytes and returns the position in the string that is the first byte of a specified occurrence of the substring. |
| JOINBYTES
|
Joins two or more text values, as bytes, as a single line. |
| MAXBYTES
|
The number of bytes in the longest line of a multiline text expression. |
| NULLIF
|
The number of bytes in a text expression. |
| REMBYTES
|
Removes one or more bytes from a text expression and returns the value that remains. |
| REPLBYTES
|
Replaces one or more bytes in a text expression. |
| SUBSTRB
|
Returns a portion of string, beginning at a specified byte position, and a specified number of bytes long. |