SQL

[Noemi]

What is an sql that I can use to update any records that has a field with
more than 8 digits?

 

[tedmi]

Update to what?

 

[Noemi]

I would like that field that has more than 8 digits to update another field
to the word "Issue"

 

[Douglas J. Steele]

UPDATE MyTable
SET SomeField = "Issue"
WHERE Len(SomeOtherField) > 0

 

[John W. Vinson]

I would like that field that has more than 8 digits to update another field
to the word "Issue"

UPDATE yourtable
SET anotherfield = "Issue"
WHERE Len([thatfield]) > 8