I want to replace null with something else for a column in a SELECT column, but cannot get the function name. Please help.
Is the expression to be checked for NULL. check_expression can be of any
Is the expression to be returned if check_expression is NULL.
replacement_value must have the same type as check_expresssion.
Returns the same type as check_expression.
The value of check_expression is returned if it is not NULL; otherwise,
replacement_value is returned.
A. Use ISNULL with AVG
This example finds the average of the prices of all titles, substituting the
value $10.00 for all NULL entries in the price column of the titles table.
SELECT AVG(ISNULL(price, $10.00))
column, but cannot get the function name. Please help.Quote:> I want to replace null with something else for a column in a SELECT
It ticks me off that Fox Team removed this rather than fix it. For
years other languages have had this ability, why not VFP.
Any suggestions for a good alternative?