>You can use
>
>update States set State = 'SP' where Len(State) = 0 && Empty state
That will not work, as all fields will have the length of the field, you need len(alltrim(State)) = 0, but I would rather use empty(State)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges