Remove unwanted characters from column

[matt.s.marotta at gmail.com]

On Monday, 27 January 2014 09:57:32 UTC-5, Chris Angelico  wrote:
> On Tue, Jan 28, 2014 at 1:23 AM,  <matt.s.marotta at gmail.com> wrote:
> 
> > If the farmID < 10:
> > remove one character from the address column
> > Elif farmID > 10:
> > remove two characters from the address column
> 
> What if farmID == 10?
>
> ChrisA

Ok, sorry this is how it should be.

If the FarmID < 10:
remove one character from the address column

If the FarmID > 9:
remove two characters from the address column

My issue is I can't figure out what statement to use to define FarmID.