>>Why is it that when I do this:
>>
>>UPDATE ACRONYM SET ACRONYM="" WHERE PKID=10575
>>
>>SQL Server 6.5 will always put a default space for a length of 1 in the table?
>>
>>How can we accomplish a length of 0 which is what I am trying to do here?
>
>Can you UPDATE with NULL?

That works.

However, the LEN() of ACRONYM is now NULL as the value is.

How would I extract that record using a SQL? I tried:

SELECT * FROM ACRONYM WHERE ISNULL(ACRONYM)

but this gives an error.

What I am trying to do is to know which records have an empty value for ACRONYM.