Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • October 28, 2010 at 7:06 pm in reply to: How To Export Empty String Instead Of (Null) From Grid #31385
    lewisaudio
    Member

    I agree, an option to replace a NULL value with an empty string when exporting results would be a great convenience. A workaround I use when creating a query to be used in a report is:

    SELECT IFNULL(FieldName, '') AS FieldName FROM SchemaName.TableName;

    The IFNULL function will replace any NULL values in the first parameter with the value in the second parameter. In this case the two single quotes returns an empty string.

  • Author
    Posts
Viewing 1 post (of 1 total)