Thread: MySQL Case Statement
View Single Post
  #4 (permalink)  
Old 06-26-2007, 11:25 AM
HelloWorld's Avatar
HelloWorld HelloWorld is offline
PT Admin
Awards Showcase
Quality Tutorial 
Total Awards: 1
Join Date: Jun 2007
Location: In front of computer...
Posts: 1,119
iTrader: (0)
HelloWorld is a jewel in the roughHelloWorld is a jewel in the roughHelloWorld is a jewel in the rough
Quote:
Originally Posted by chrishirst View Post
using the IsNull(column) function would be a better solution
it is a better solution to use is Null because we cannot compare null with logical comparison. Just tried it today

__________________
Digg this Post! Del.Icio.Us this Post! Technorati this Post! Furl this Post! Mister Wong this Post! Newsvine this Post! Spurl this Post! Reddit this Post! Netscape this Post!
Reply With Quote