Stop the rounding

[Kenneth Brody]

Quoting Keith Weatherhead (Fri, 14 Sep 2007 13:41:56 -0500):

> Hmmm, maybe...
>
> cb = mid(25,"1","7")
[...]

FYI -

That won't work if the value is larger than 9999999 or less than -999999,
nor will it work if field 25's length or type changes in the future.

As several others have pointed out, INT() is the "right" way to do this.

-- 
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com