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:
What I need to have happen is for it to be held (rather than simply formatted) in the DB as a complete number:
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.