More fun with nulls Database concepts Add comments Jul 232012 Click the image for a scripted example Share this:FacebookGoogleTwitter select posts from sqlfail where content like :this_post; Yes, yes you can index nulls More fun with nulls and (bitmap) indexes NULL handling 2 Responses to “More fun with nulls” Sujoy says: July 23, 2012 at 11:42 Singed my hands badly with this once. Though to be fair, I did not know that the values_including_nulls column contained null values. Thanks for reminding again! Reply Chris Saxon says: July 23, 2012 at 20:46 :) I’ve been caught out by it too – I think some things stick better if you learn the hard way! Reply Leave a Reply Cancel reply Your Comment You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> Name (required) E-mail (required) URI Notify me of follow-up comments by email. Notify me of new posts by email.