Replace null values with just a blank

IFNULL is an Oracle extension (adopted by many other platforms). The "standard" SQL function is coalesce():

SELECT COALESCE(columnName, ' ') AS ColumnName
FROM tableName;

In your select you can put an IsNull/IfNull round the column. Not particularly efficient but does what you want.

MS SQL

Select IsNull(ColName, '') As ColName From TableName

MySQL

Select IfNull(ColName, '') As ColName From TableName

Related