Applies to: Databricks SQL Databricks Runtime
expr, right-padded with
pad to a length of
expr: A STRING or BINARY expression to be padded.
len: An INTEGER expression.
pad: An optional STRING or BINARY expression with the pattern for padding. The default is a space character for STRING and x’00’ for BINARY.
A BINARY if both
pad are BINARY. Otherwise, returns a STRING.
expr is longer than
len, the return value is shortened to
If you do not specify
pad, a STRING
expr is padded to the right with space characters, whereas a BINARY
expr is padded to the right with x’00’ bytes.
len is less than 1, an empty string.
BINARY is supported since: Databricks Runtime 11.0.