i trying to get in a 3 digit "INT" field, the leading zeroes.
substantially i need to change "1" to "001" or "12" to "012" and so on.....
executing the query ....
substr('000' + cast(ID_FD AS CHAR(3)),3) as ID_FD_modificato, ID_FDFROM DXDWH_IRION_VW.DWH_FD
i get something wrong
.00000000000000E 000 3
could you gently help me in this trouble?