Hi,


I'm really sorry for the late answer.

Imagine a Query like this:

SELECT tabEu.descricao, tabEu.stamp, ISNULL(tabGu.descricao, '') AS grupo,
ISNULL(tabGu.ordem, 0) AS ordem
FROM tabEu (nolock)
LEFT JOIN tabGu (nolock) ON tabEu.st_tabGu = tabGu.stamp
ORDER BY grupo, ordem, tabEu.descricao

We could find the records with GRUPO field blank:

SELECT ...
SCAN FOR EMPTY(grupo)


The truth is... it doesn't work... with SQL Server 2000, evertyhing is Ok!


I'm going nuts.


Best regards,


Ricardo Almeida