>>>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.

Mike:

What size is the SQL field defined as? Is it defined as Char or VarChar?

Ed