I'm currently working on a database application where the application can show a number of risks and counter-measures.
Now i'm updating the application so it is possible to upload new risks without having to open the database.
However, each risk has an riskID, a number that was being put in a string, because it had to be exactly 4 characters long.
so there's riskID 0001, 0002,...,0020 etc.
Those risks were put in by hand, but now everytime i try to insert a risk into the database, it cuts away the zeroes.
(even if it has them in the SQL string).
Is there any way i can force the database to force the database to put the zeroes there?
i'm willing to do some digging to see if converting it to an int hurts, if that's necessary