You can also use SELECT ISNULL(myColumn, 0 ) FROM myTable
Reference: http://www.w3schools.com/sql/sql_isnull.asp -- View this message in context: http://lucene.472066.n3.nabble.com/Replace-NULL-with-0-while-Indexing-tp4095059p4095550.html Sent from the Solr - User mailing list archive at Nabble.com.