N
Noemi
What is an sql that I can use to update any records that has a field with
more than 8 digits?
more than 8 digits?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
tedmi
Update to what?
N
Noemi
I would like that field that has more than 8 digits to update another field
to the word "Issue"
to the word "Issue"
D
Douglas J. Steele
UPDATE MyTable
SET SomeField = "Issue"
WHERE Len(SomeOtherField) > 0
SET SomeField = "Issue"
WHERE Len(SomeOtherField) > 0
J
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