>>>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);
>>
>
>Hi Antonio,
>I forgot that SQL Server has ISNULL() function (equivalent of NVL of VFP). This should work.
>Thank you very much!
Great!
For the record, NVL() is in use in ORACLE, too.
----------------------------------
António Tavares Lopes