Check if SQL Server 2005 XML field is empty
Hello, I just did this: Delete FROM MyTable WHERE ScopeValue = "" Delete FROM G_Scope WHERE ScopeValue is '' Delete FROM G_Scope WHERE ScopeValue = empty Delete FROM G_Scope WHERE ScopeValue is empty I want to delete all rows with xml field (not nullable) where ScopeValue column has empty entries means zero chars. Anyone knows? ...