Count haracters in table field and update second field if over lim

  • Thread starter Thread starter Maver1ck666
  • Start date Start date
M

Maver1ck666

I have a table with a bunch of addresses in split down into Add1 through to
Add6. The amount of lines could range from 100 to 10,000.

I have some code that goes through and if certain parts of the address match
a certain criteria (like a pre set country name), it updates a seperate
column with an identifier (like "Foreign") for that coresponding record.

This all works fine but what I also need it to do is count the characters
already in the field and if they are over a certain value (say 30 chars
long), then for it to update another column with "fail".

Any ideas please?

Kind regards,
Mav
 
Back
Top