LPAD (left pad) and RPAD (right pad) are functions used to add padding characters to the left or right side of a string up to a given length. The functions are used as follows:
lpad(text, pad_char, length)
rpad(text, pad_char, length)
End User Licence Agreement (EULA).
Changed scripts to allow an integer to be passed in as the text value.