Posted by Madhivanan on 10/04/43 11:57

You should compare Null with is

where value='' or value IS Null

Madhivanan



Cylix wrote:
> Is there any difference between a nText field value='' and value=NULL ?

• Next in forum: Server configuration for MSSQL 2000 and MSSQL 2005
• Prev in forum: Re: Facing some problem in Instead of Trigger for MultiRow Insert
• Thread view: Re: Query performence about nText

[Reply to this message]