jakebutt14

ExecuteSQL - Number with leading zeros

Discussion created by jakebutt14 on Feb 13, 2017
Latest reply on Feb 14, 2017 by jakebutt14

Hi everyone -

 

I'm using ExecuteSQL to retrieve data from a number field which has the possibility of leading zeros (non-decimal). I'm getting the expected list of values, except those values with leading zeros are having the zeros stripped off. Here is my function, it's pretty simple:

 

ExecuteSQL ( "SELECT clientCodeNumber FROM Clients ORDER BY clientCodeNumber" ; "" ; "" )

 

Anything I can throw in there to make sure these numbers don't get the zeros stripped, or am I SOL with ExecuteSQL? (near pun intended). I have found some other discussions regarding this happening with leading zeros with decimals (i.e., 0.99 turning into .99), but all of my values are whole numbers.

 

Thanks in advance.

Outcomes