>Hi,
>
>I have the following SQL Select (simplified):
>
>

>cSqlselect = "SELECT " + cGroupField + " AS GROUP_ID " ....   GROUP BY " + cGroupField
>

>
>I want all records where the cGroupField is empty or NULL to be grouped into one record. But I get one row for all empty values and one row for all NULL values.
>
>How do you suggest I change the above SQL Select?
>
>TIA

Dmitry

Assuming you're working with MSSQL Server, use the ISNULL() function to transform NULL values into empty ones. For instance, for a column X with data type integer (null):

SELECT ISNULL(x, 0) FROM table_x GROUP BY ISNULL(x, 0);