A question arose when assembling an sql statement. I have several records in a table called db_contrato
, I wanted to add the number 0 in front of all the records, for now I defined the contract column as varchar (50).
db_contract
id|contrato
1 |3094 --> 03094
2 |4058 --> 04058
3 |2020 --> 02020
4 |1620 --> 01620