Shyam Steel Industries Web Development Intern Interview Questions and Answers

lpad and rpad are functions used in SQL to add padding characters to the left or right of a string.

• lpad adds padding characters to the left of a string

• rpad adds padding characters to the right of a string

• Syntax: lpad(string, length, padding_character)

• Example: lpad('123', 5, '0') will result in '00123'

• Syntax: rpad(string, length, padding_character)

• Example: rpad('123', 5, '0') will result in '12300'