Is there a way to insert a null character whlie using the query builder in Enterprise Manager?

  • We are currently trying to debug an issue in a purchased system.  I've tried inserting a value using query analyzer.  It says the record is updated, but when we look at the data, it appears to not have been updated.  So we're trying to manually update it by using the query builder against the table.  We're trying to replace the current value of 1 with a NULL value.  Does anybody know how to insert a NULL value by using the keyboard?  Thanks!

  • <ctrl> + 0 will insert a null. Hold ctrl and press 0 key. Tab out of field to see the null.

  • Tony,

       Thanks a ton!  It did the trick.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply