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