AnsweredAssumed Answered

Leading zeros

Question asked by Stu412 on Jul 5, 2016
Latest reply on Jul 6, 2016 by mikebeargie

Hi there

 

Bit of a dumb one, but it's late in the day....

 

I have data which I'm looking at in table view for a particular field:

 

.71

.45

2.71

.38

 

What I need to have happen is for it to be held (rather than simply formatted) in the DB as a complete number:

 

0.71

0.45

2.71

0.38

 

These numbers then are used wholly further downstream by ExecuteSQL which otherwise would use the decimal point as a delimiter.  However, if I have the zero in place first, this is no longer a problem.

 

Only problem is that I have 21,000 records to fix.....

 

Any ideas gratefully received.

 

Thanks

Outcomes