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.