>Can anyone explain why there is a difference to send a character string like "0019" when using SQLEXEC - UPDATE vs SQLEXEC - INSERT. When using INSERT the result in the SQL -table is "19" and when using UPDATE the result is "0019". I would like to use INSERT for some reasons and I also like to get the result "0019" but I do not know what to do.
Hi,
take into account what data type is your field and how your statements are written. SQL has internal type converting and it seems for me that when you make insert your data is written not as a string, but as a number. SQL converts it to string but this removes leading zeroes.
Venelina Jordanova
Outsourcing IT Services Ltd.