>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement