>>>>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)
>>
>>In this case EMPTY(State) should work (assuming State is not a memo field).
>
>Empty() works on any type of field or expression, that's the beauty of it. Even memos.

Yupp, only marred by erroring out on objects...