AnsweredAssumed Answered

Import into database drops leading zeros

Question asked by Lowell on Aug 9, 2016
Latest reply on Aug 10, 2016 by Lowell

Hi All,

I have a GEL import script that drops the leading zeros in the data.  Is there a way to retain those leading zeros?


Would I need to wrap the items in some function?

The field is "varchar" in the database.

0405 becomes 405



      <core:forEach begin="1" items="${input.rows}" trim="false" var="row">
        <core:catch var="ex2">

             INSERT INTO trg_lawson_data_stage

             VALUES (?)
            <sql:param value="${row[4]}"/>