Convert NULL to empty string
Posted: Mon 17 Oct 2011 16:25
Hi! We are testing MySQLDataTable as datasource for a datagrid. We have a MySQL DB with a table of 30 fields. 25 of them are string field, which not accept NULL. When making a new record in this table, we start with data in only two fields. Is it possible to convert NULL to empty string so we dont have to set the 25 other fields to blank? Thanx. Ole