I have a column recipient_id, the column length should be only 12 digit, if it is less than 12 digits, then zeros should be padded on the left to make the column as 12 digit, we have to use SQL query for it.
I tried appending zeros, but still am getting 9 digits
New contributor
Priyadharshini kannan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.